Sample Header Ad - 728x90

Three tables with some matching data and some not - want to data from all three

0 votes
2 answers
212 views
I have three tables Costs (47 rows) Budgets (60 rows) Committed Costs (12 rows) All three have the same 2 fields and than a number JobNumber, CostCode, (either costs, budget, commitedcosts) They all have the same JobNumber and they all CostCode in common. However they also each have unique CostCodes. I need to run a query that would get me results from all three tables like this: JobNumber, CostCode, Costs, Budgets, CommitedCosts Currently I am using outer joins on the three tables and only getting 47 results since the Costs table is the first table selected from.
Asked by Patrick Bergmann (1 rep)
Feb 22, 2019, 07:59 PM
Last activity: Jun 27, 2025, 05:03 PM