Full Outer Joins supported? unsupported?

Has anyone tried using a TSQL full outer join and managed to get it working? Any documentation for Full Outer Joins in CE?

Any ideas? Thanks, Bill

It appears that FULL OUTER JOINs are not supported, according to: http://msdn2.microsoft.com/en-us/library/ms174853.aspx

ful text index

I just created a full text index on a table and everything appears fine but
after populating it I still have an item count of zero. Any ideas?
tia,
jjTry executing Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
where pubs is replaced by the databse name in question. Assuming this
returned a 1, check through the eventlog to see if there are any errors. I
suspect there are.
Does this server have BUILTIN\Administrators account setup as sysadmin? If
not check out the KB 317746 article.
If this doesn't produce any results look at the following 2 KB articles:
277549 "PRB: Unable to Build Full-Text Catalog After You Modify"
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
317746 "PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
HTH
Francis
"jj" wrote:
> I just created a full text index on a table and everything appears fine but
> after populating it I still have an item count of zero. Any ideas?
> tia,
> jj
>
>