Using PHP and MySQL query results.

[thatos]

I have two results which I got after performing two and I want to left join those two tables, will this work. e.g.

[code]
$query1 = "select sample__code, location from sample";
$query2 = "select sample_code, value from ion_data where ion_id = 1";
$result1 = mysql_query($query1);
$result2 = mysql_query($queyr2);

//How do I perform a left join between the two

//or will this work
$query = '( $query1 left join $query2 where sample.sample_code = ion_data.sample_code)';

[Rabbit]

You can just write one sql string with the left join. There's no need to separate them and then try to join them afterwards.

[thatos]

But for ease of use can't I just have different statements and then concatenate those strings to form the final query?

[thatos]

Or it this possible.

$query = "(select s,m from R left join select s,n from P where R.s = P.s) left join select s,p from A where ?.s = A.s";
 

[Rabbit]

That's not syntactically correct SQL so no, you can't use that exactly. But in concept, you can do that.