Thread: Select data from two tables

I have two tables acc_accounts and lst_lost and a combobox cboUrl.

I need to select the email fields named ACC_Email and LST_Email where the value from cboUrl exist in either one or both tables. The data could be in both or only one of them.

I tried something like this:

SELECT ACC_Email,LST_Email
FROM (ACC_Accounts
				LEFT JOIN LST_Lost ON ACC_Accounts.ACC_Url = LST_Lost.LST_Url)
WHERE [ACC_Url] LIKE [Forms]![ACC_Accounts_frm]!cboUrl AND LST_Url LIKE [Forms]![ACC_Accounts_frm]!cboUrl

Thank you

Right. Thanks man. I didn't know where my head was.