Eron,
You'd be surprised what some experimentation with the Access query
builder will net you. But here are a couple of snippets that might shed
some light on it for you.
SELECT Person.persid, Person.FN, Person.LN, Pers_works.*
FROM Person LEFT JOIN Pers_works ON Person.PersID = Pers_works.PersID
WHERE person.persid = #ID#
or, adding in a right join:
FROM (Person LEFT JOIN Pers_works ON Person.PersID = Pers_works.PersID)
RIGHT JOIN PersCounty ON Person.PersID = PersCounty.PersID
WHERE ( ((PersCounty.CntyID)='#ID#'))
The parentheses help you see what's getting joined to what.
HTH,
--John Allred
Eron Cohen wrote:
>
> Hi Everyone,
>
> I am wondering if anyone knows the correct syntax for doing a LEFT JOIN in
> the WHERE statement of an MS Access Database query.
>
> I was told that it should be something like:
>
> contact_table.contact_ID =* sales_information.sales_contact_ID
>
> but this throws a syntax error:
>
> Syntax error (missing operator) in query expression '0=0 and (show='ABC')
> and (email_address_is_primary=1 and Contact_Phone_number_is_primary=1) and
> company_master_table.visible=1 AND contact_table.contact_ID =*
> sales_information.sales_contact_ID
>
> Any ideas appreciated!
>
> Eron
>
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
John Allred / Jackson, Mississippi
Mississippi Counties
http://www.mscounties.com/
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
