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
Last activity: Jun 27, 2025, 05:03 PM