Selecting 2 tables from 1 query

[Mutley]

I have 2 tables and want 1 query to select 1 field from table_a and 2 fields from table_b then display them using:

 

		while($row = mysql_fetch_array( $result ))
    	{
echo $row['field1_table_a'], $row['field2_table_b'], $row['field3_table_b'];
}

 

...any assistance would be great.

[PC Nerd]

ok but i think it goes like:

 

 

SELECT table_a.column_name, table_b.column_name, table_b.clolumn_name FROM table_a, table_b WHERE ID = 'VALUE'

 

it will change for your database.... and you have to have a pre set up relationship between the two tables....... i can look it up if you want, but someone probably knows off by heart

 

 

good luck

[Mutley]

Ah, sorry, should of added. For each there will be a different WHERE clause.

[Barand]

How should the tables be joined? which column in first table matches which column in second table?

 

try

<?php
$sql = "SELECT a.field_1, b.field_2, b.field_3
        FROM table_a a INNER JOIN table_b b ON a. field_x = b.field_y
        WHERE a.field_p = 'something'
        AND b.field_q = 'somethingelse'";
?>