How do I select two tables from the same database?

Ben · 31st March 2005, 09:47 AM

Hey there,

I did a search and couldn't find anything.

I think I might have seen this before but can't remember...

If possible, how do I select from two tables in one database in the one query?

Eg:

Code:

select row from table1,table2

Thanks

**Mr. Tech** · 12th April 2005, 11:25 AM

Hey Ben,

Try this code:

PHP Code:


		
			
$query = mysql_query("SELECT table1.field1, table2.field2 FROM database");

while($row = mysql_fetch_array($query)) {

echo $row['field1'].' '.$row['field2'];

}

If the two fields have the same name then you'll need to tweak, but we'll get to that if that's the case. If you have a WHERE clause on the two fields then it can get icky and you might need to be careful.