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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Are you having a specific problem doing so?
yes i canot make the query to appear the rooms fuctional whit the capacity avaible
Click to expand...
What is the structure of your second table?
the first table call rooms have the structer of building (idroom, level, nºdoor, capacity, funcional)
Click to expand...

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
 
Back
Top