Two table left join with 4 keys

Hi,

I have two tables, A and B, each has 7 columns and 4 keys. I would like to left join by the 4 keys and show the rest 3 columns of both table into a new table, with only one set of the keys.

The purpose is to compare the two tables.

How to do that?

Thanks,

Jennifer

[Rik]

What have you tried? I don't fully understand what it is exactly that you want to do, but it sounds like you will benefit from a look at the documentation for the table class and/or the unique function.

[Peter Perkins]

Have you looked at the join, innerjoin, and outerjoin functions?