Table short name

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

 

[John Webb via AccessMonster.com]

I think this should do it:

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

i think....

Cheers

John Webb

 

[SillySally]

It did- thanks for the help!