how i make a query on two tables Ex.Hotel rooms and ocupied?

[Guest]

i have one table call rooms (level,door,capacity and functional) and other
table that have the movements of rooms, i want to create a query that give me
the result of a room that have the capacity avaible and are funcional

 

[John Vinson]

i have one table call rooms (level,door,capacity and functional) and other
table that have the movements of rooms, i want to create a query that give me
the result of a room that have the capacity avaible and are funcional

Are you having a specific problem doing so?

What is the structure of your second table?

REmember, YOU can see your database. We cannot.

John W. Vinson[MVP]

 

[Guest]

Are you having a specific problem doing so?
yes i canot make the query to appear the rooms fuctional whit the capacity avaible

What is the structure of your second table?
the first table call rooms have the structer of building (idroom, level, nºdoor, capacity, funcional)

the second table are the movements of room (idmovement, idroom, name of
person)

if the room have 2 of capacity and only one person are in the room, i have
one capacity avaible and more rooms that are funcional but they are not in
the table movements