Matching a set of data from one table to another
430487Jun 17 2009 — edited Jun 17 2009I have a table - Table_1 with columns A, B, C, D. I have another table (Table_2) with columns B, C, D.
I'm trying to get all the rows from Table_1 where the values match for columns B, C, D.
The catch here is that the rows returned from TABLE_1 should be the same number of rows as in TABLE_2 and the value in TABLE_1 of "A" should be the same for all those rows. So - Table_1 could return multiple sets of matching data where the VALUE for A differs for each SET but - the "SET" should match all the other values in TABLE_2 exactly (including number of rows for each set)...
Any help is greatly appreciated. Hopefully I've stated the above clearly enough.