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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing {PAGE/*MERGEFORMAT} from my microsoft document 5
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Nested query problem 6
HELP WITH Access QUERY PLEASE :) 8
SQL: Inner Join Works, Left Join Does Not 1
Office add-in registration error - Component not correctly registered 0
Multiple left joins 3
Min and Max for Date Range in Report 4

Top