Joins and Variables

[Anon]

Lets say I want to join 2 tables:

$query1="select * from waterfront, Bloodhound where waterfront.agent_id=Bloodhound.ID";

From this query I have a formatted output which displays my nice looking results from my query. Now I want to take the columns present in the Bloodhound table that match the agent id and have them available in this query. So where agent_id in the waterfront table equals the ID in the Bloodhound table. Make available the columns in the Bloodhound table. For example Agent_id 33 matches ID 33 in the Bloodhound table. I want to also take Agent_first and Agent_last columns in the Bloodhound table from that row and make it available in my query. So would I simply call it as a variable such as $Agent_First=Bloodhound.Agent_First or what?

Any help is appreciated.

[Anon]

I answered it myself. Thanks anyway. For those of you needing to know it's like this:

select * from table1 1, table2 2 where 1.matchingfield=2.field

You define your tables first such as table1 and give them a shorter name such as 1 etc.. Then define the field in the table that matches the second table. Note: if you have a sort by use your abbreviated table name.

1.city,1.state,1.zip ASC