I need to modify a copy of a query to add an additional table.
The original "top part" of the query is below.
Code:
SELECT OrganizationsT.*, ContactsT.ContactFullName, ContactsT.PrimaryContact, ContactsT.PrimaryContactText, ContactsT.ContactPhone, ContactsT.ContactEmail, ContactsT.ContactAddress1, ContactsT.ContactAddress2, ContactsT.ContactCity, ContactsT.ContactState, ContactsT.ContactZip, ContactsT.ContactFirstLast
FROM OrganizationsT LEFT JOIN ContactsT ON OrganizationsT.OrgName = ContactsT.ContactOrg
It's allowing me to add the table to the SELECT portion: YPsT.*
However, it's not letting me put an "&" or "and" clause in the FROM portion. I need it to be FROM (what is in the code now) and also FROM the YPsT.
How would I get that in there?
Thanks!!!
--ak