SQL Help

[admin]

I have two tables (actually a lot more, but these are the ones I am dealing with). Here is an example of my problem.

Table1
------------
relHouseID
relCountyID

Table2
------------
CountyID
CountyName
BuildingCodeID

I want to list the relHouseID of all the Houses that have the same BuildingCodeID. Every county has the same building code. So I want to have a query that gets the BuildingCodeID to then in turn get all the Houses that have the same BuildingCode.

Please Help Me.