I have a Microsoft Access query question.
There are three tables:
table rooms contain fields: room_number | room_ref
table occupant contain fields: room_ref | personid
table person contain fields: personid | firstname | lastname
The issue is there could be 0,1,2 or...