How to link tables/excels with more than one common columns

[Anonymous]

I have 2 excel sheets project and Sale

Both Project and Sale excel sheets have the field ProjectID and saleID. I need to link the two tables avoiding a synthetic key.

Is it suggested that I comment SaleID in the Sale file and link both Project and Sale file using ProjectID.

Please give me a solution so that there are no data issues.

[swuehl]

Please avoid posting the same request multiple times.

It makes it hard to follow a discussion and is a waste of ressources.

How to link 2 tables with more than one common fields

[nevilledhamsiri]

Do a left join so that you may get the one common field right in the left with no synthetic keys being created!

Neville