I have 7 Purchase Order Tables
Each table has an identical structure.
I have another table tblJob. Each Purchase Order has a unique Job number from tblJob.
If I had just one Purchase Order table I could create an inner join between tblJob and tblPOCox.
How should I do the same but with 7 Purchase Order Tables (rows tblJob will have one matching PO in any 1 of the 7 PO tables) .
I know how to append all of the 7 tables into one using Union All but don't know if this is the right route and if it is what I should do next. If the answer lies with a temp table please descibe.