Does *= exist in Access?

G

Guest

Does *= and =* exist in MS access as left and right joins or do we have to
use the Right Join, left join keywords?

Thanks,
VM
 
D

Douglas J. Steele

You need to use the keywords. (In fact, I believe SQL Server is moving away
from that notation as well, as it isn't standard)
 
G

Guest

And can I use the keywords Right Join in the From and the '=' clauses in the
Where ? Or can I only use one notation?

Thanks.
VM
 
D

Douglas J. Steele

Yes, Right Join is only in the From part. The Where section uses the
algebraic operators.
 
Top