Two table left join with 4 keys

JFz

2017 5 23

0 个回答

7 次查看（30 天）

0 个投票

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

2 个评论
显示无隐藏无

Rik 2017-5-23

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.