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).