I have 3 tables.
one of the tables is a linked table, so it contains the primary key from table 1 and primary key from table 2 as foreign keys. together they make up the primary key for the linked table.
Now i need to find out which items are not in the linked table.
example : table A contains camping facilities, table B contains availability periods, table C is the cominbination of the chosen camping facility with a specific period. Now i need to know which facilities and periods are still available (all combination not in table C)
January 21, 2008 11:01 AM
January 24, 2008 5:18 PM