JapanFreak
Registered User.
- Local time
- Today, 20:57
- Joined
- Aug 25, 2007
- Messages
- 45
Apologies, probably a dumb question but I can't find the solution:
I have two tables, let’s call them A and B. B is a sub-set of A, i.e. every item in table B can be found in table A, but not every item of table A can be found in B.
Both tables have the same columns. One column is called “Member of B” and shall be filled with “True” or “False”. In table A however this column is currently empty; in table B it says “True” for all of the items.
I’m looking for a query which gives me a table with all items of table A and the information, whether the items are “Member of B”, indicated by True or False.
I have two tables, let’s call them A and B. B is a sub-set of A, i.e. every item in table B can be found in table A, but not every item of table A can be found in B.
Both tables have the same columns. One column is called “Member of B” and shall be filled with “True” or “False”. In table A however this column is currently empty; in table B it says “True” for all of the items.
I’m looking for a query which gives me a table with all items of table A and the information, whether the items are “Member of B”, indicated by True or False.
