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.
