Select data from two tables

[Zaeguzah]

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:

Please Login or Register  to view this content.

Thank you

[OnErrorGoto0]

I think you would need a UNION query to extract the fields from both tables, where the url is the one you want.

[Zaeguzah]

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