SQL Help

[Anon]

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.

[trippyd]

select t1.relHouseID from Table1 t1, Table2 t2 where t1.relCountyID = t2.CountyID and t2.BuildingCodeID = someRandomNumberYouMadeUp

D

[Anon]

That works for the second half of the problem, but first I want to get the BuildingCodeID for a specific house. Right now I could do that in two separate queries.

SELECT BuildingCodeID from Table1 t1, Table2 ts WHERE t1.relHouseID = "432" and t1.relCountyID = t2.CountyID

Then use mysql_fetch_array() to get the value then parse it back into this query.

SELECT relHouseID, BuildingCodeID from Table1 t1, Table2 t2 WHERE t1.relCountyID = t2.CountyID and t2.BuildingCodeID = "45690"

I would prefer to have this in one query. Can anybody help?