Table short name

  • Thread starter Thread starter SillySally
  • Start date Start date
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!
 
I think this should do it:

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

i think....

Cheers

John Webb
 
SillySally said:
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:
Click to expand...
Thanks for the help!
Click to expand...

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.
 
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.


.
Click to expand...
 
Back
Top