How To Relate Multiple Tables?

Hi all,
Lets say that i have 3 tables, they are already related together, information on each of the 3 tables and their relationship between eachother can be found below:
I am using Microsoft SQL Server 2005 Database in Visual Web Developer 2008 using VB programming (ADO.NET)
The 3 tables are as follows:


Floor
Room
Location


Fields inside each of the tables can be found below:



Floor Table
(PK) ID
(Required) Name
DisplayOrder


Room Table
(PK) ID
(Required) Name
(PK, FK) FloorID
ExchangeID
Extension
IP
DeviceName
Remarks
(Required) Equipment
(Required) Floor2ID
FloorLocationX
FloorLocationY


Location Table
(PK,FK) FloorID
(Required) CountryName
(Required) CityName
(Required) BuildingName


The Relationships between the 3 tables are as follows:


ID field in Floor table is referenced by the field named FloorID in the Room Table

ID field in Floor table is referenced by the field named FloorID in the Location table


NOTE: Location Table serves only as an extension to Floor table thus they have a 1 to 1 relationship, due to My Projects Lead's instructions I am not allowed to consolidate the Floor Table and the Location Table as 1 whole table.

Floor Table has a 1 to Many Relationship with the Room Table.


I Have already done the physical relationships between each of the 3 tables in the Database Diagram, in Visual Web Developer 2008 Express Edition under the Database Explorer

So i have created this form to accept user input:

this form is in a aspx page called AddRooms.aspx

Country Name:______________ (data sent to location table)

City Name:_________________ (data sent to location table)

Building Name:______________ (data sent to location table)

FloorID:[This is a DropDownList which is databinded to the Floor Table]

Room Name:_______________ (data sent to room table)

*Just imagine that the above is a form to accept user input

*With a hit of a submit button all data will be sent to their respective tables in the database

Now i know that i have to JOIN tables in my database in order for my application to work, but i have no experience performing JOIN, i need great guys like you to help me apply JOIN to the 3 tables mentioned above, do let me know if you have any doubts in what i am trying to do.

Do give me that code that i can either apply in the (VB environment Visual Web Developer 2008) and/or in Microsoft SQL Server 2005 environment


Just need the SQL Statment that i will need to construct to perform the JOIN i need to.



Please Help

Many Thanks : )