So here are tables from SQL EXEC SP's that forms synthetic keys.
What is the best way to create link table to eliminate synthetic keys from a SQL EXEC commands ?
[Sales ] :
Sales ID
Order ID
Customer ID
[Orders] :
OrderID
CustomerID
ProductID
[Product]:
ProductID
OrderID
Sales ID