3 Replies Latest reply: Oct 24, 2018 1:15 PM by Hector Munoz RSS

    Can link tables be created from  SQL SP's ?

    Claudia Lettten

      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