Does *= exist in Access?

[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

 

[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)

 

[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

 

[Douglas J. Steele]

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