Joining tables

[Boris613]

Hi All!
I have two tables. Table Heffalump which has field "DealGroup" and other fields as well... and table 8-YTD Principal Investments whic has field "book" and other fields as well... I need to use BOOK and DEAL Group as a combination primary key to compare against table 8-YTD Principal Investments. If there is a new DEAL GROUP then append into table "8 - YTD Principal Investments"

THANKS IN ADVANCE,
B

 

[johncallaghan]

You have not explained your problem very well. Please give some example fileds for each table.

Cheers

 

[The_Doc_Man]

In general, the action you describe is NOT going to work as a JOIN unless you have left out something.

JOIN is used when the same values exists for corresponding fields in two tables. Appending would not be necessary if the JOIN would work because the entry would exist already.