R
roseberryv
Is there a way to create a query that excludes items if they appear in
a certain table? I know you can use an inner join to restrict results
to those items that appear in both tables, and an outer join to include
all the items in one table, and those from the other table that match.
But if you link table A, which contains information on all items, and
table B, which contains a subset of those items, can you indicate that
if an item appears in table B, exclude it from the query results?
a certain table? I know you can use an inner join to restrict results
to those items that appear in both tables, and an outer join to include
all the items in one table, and those from the other table that match.
But if you link table A, which contains information on all items, and
table B, which contains a subset of those items, can you indicate that
if an item appears in table B, exclude it from the query results?