Query linking two tables with equal field

[DanJames]

Hi,

I have two tables:
tblClientDayJunction and tblCleanerDayJunction

These hold the ID, ClientID/CleanerID and Day (which is a number 1-5)

I would like to be able to link Client Name - Cleaner Name in a query, depending on wether the Day fields equal the same value.

For example, If the tblClientDayJunction record says
1, 209, 3 - ClientID 209 has the day Wednesday (3)

and tblCleanerDayJunction record says
4, 89, 3 - CleanerID 89 has the day Wednesday (3)

so in the query it would show
ClientID, ClientName (from tblClients), CleanerID, CleanerName (from tblCleaners), Day

So the record would say:

209, Clients Name, 89, Cleaners Name, Wednesday

Any Ideas?
Thank you in advance,
Dan

 

[MStef]

What is the RELATIONSHIP between these 2 tables??