I have two tables that are referenced:
fields:floorId,name,BuildingId(linked to buildings table using buildingId)
Curently if i select all the details from floors table it will give all the details.
But i want Building name to be displayed instead of buildingId.
Output should look like:
floorid name buildingname
1 first xyz building
2 second xyz building
3 third xyz building
what is the SQL query required to get the above output.