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

 

[Chris2]

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:

Thanks for the help!

SillySally,


FROM Groups AS G1
INNER JOIN
(Contacts AS C1
INNER JOIN
GroupMembers AS GM1
ON C1.ContactID = GM1.ContactID)
ON G1.GroupID = GM1.GroupID

(Untested, of course.)

Sincerely,

Chris O.

 

[SillySally]

It did- thanks for the help!

 

[SillySally]

Thanks for the help- I appreciate it!

-----Original Message-----




SillySally,


FROM Groups AS G1
INNER JOIN
(Contacts AS C1
INNER JOIN
GroupMembers AS GM1
ON C1.ContactID = GM1.ContactID)
ON G1.GroupID = GM1.GroupID

(Untested, of course.)

Sincerely,

Chris O.


.