how to combine data from multiple tables into one master table using sql
I have 3 tables (JM, JCD, and JEO). JM is the parent with PK JobNo. JCD and JEO are both children to JM with FK's JobNo.
Below is the desired output table from the 3 tables I am writing the query for.
Any ideas on what the code would be to achieve this?
(Note the resultant table does not include any rows where JCD.CostType is equal to 90).
Users Browsing this Thread
There are currently 2 users browsing this thread. (0 members and 2 guests)
Tags for this Thread