5 Replies Latest reply: Dec 16, 2011 11:06 AM by Rob Wunderlich RSS

    Bringing a field from one table to another (Outer Join)

      Hello,

       

      I have a table , in my example attachement Orders, that I would like to add a field to (State Name). State Name resides in the State table which is not directly associated with Orders. Orders associates with All Facts which associates with State. How can I use outer join in my script to bring in State to my Orders Table? I would then rename this to OrdersState to avoid a circular referecne. The attatment should make things a bit more clear.

       

      Thanks!

      Jeff