Query several fields in one table from another table
Posted on 2013-12-03
I have a table looking like this:
Then I have a second table looking like this:
name (Smith, John)
what I need to do is to get all records from the first table that are not part of the second one based on firstname, lastname and city. The name is stored in a firstname and a lastname in the first but they are in one column in the second.
How can I accomplish this in a query?