Query2 tables to create one list?!?

[deadelvis]

I have a db which enables users to enter expenses.

tblExpense
tblExpenseDet
tbleExpenseMileage

tblExpenseDet & tblExpenseMileage are joined to tblExpense

As the expenses are entered at User Level not Client Level, I need to extract the Client ID from the 2 sub tables to create a list grouped by client so we can report the billable expenses.

I'm thinking union query but wouldnt know where to start.

Any help would be appreciated

Ta

 

[deadelvis]

Its OK i've sorted it with a union query

SELECT * FROM UnionExpDet
UNION
SELECT * FROM UnionExpMil
ORDER BY PeriodID;