Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please avoid posting the same request multiple times.
It makes it hard to follow a discussion and is a waste of ressources.
Do a left join so that you may get the one common field right in the left with no synthetic keys being created!
Neville