Table short name

S

SillySally

One more syntax question. I want to use:
Contacts as c1

But now I have multiple tables in the query (syntax
nightmare!) and I'm not sure where to designate Contacts
as c1 given that my FROM clause is:

FROM Groups INNER JOIN (Contacts INNER JOIN GroupMembers
ON Contacts.ContactID = GroupMembers.ContactID) ON
Groups.GroupID = GroupMembers.GroupID

Thanks for the help!
 
J

John Webb via AccessMonster.com

I think this should do it:

FROM Groups INNER JOIN (Contacts AS c1 .....

i think....

Cheers

John Webb
 
Top