table join (merge)

badre

I have two tables with exactly the same column number and name. I simply want to "merge" them together, then order into an array. Tried about everything but haven't gotten anywhere? Here's some code that doesn't work, just got rid of junk. Ideas.

$qr = mysql_query("SELECT * FROM dittmli, cal_main WHERE

LEFT(dittmli.mdate, 6) = LEFT(cal_main.mdate, 6 ORDER BY mdate");

Thanks, B

Anon

$qr = mysql_query("SELECT FROM dittmli union select from cal_main order by mdate");

badre

Thanks for responding. This first snippet brings in one table perfect, then I rewrote following your lead to "union", then it doesn't do ...Am I missing something else. Thanks, B

$qr = mysql_query("SELECT * FROM dittmli WHERE LEFT(mdate, 6) = '".$tab."' order by mdate");

$qr = mysql_query("SELECT FROM dittmli WHERE LEFT(dittmli.mdate, 6) = '".$tab."' union SELECT from cal_main WHERE LEFT(cal_main.mdate, 6) = '".$tab."' order by mdate");

Anon

I don't see any problem with your query. What do you mean by "doesn't do""?

No rows? Any error message?

You should always have an error check after each dbms call

$qr = mysql_query("SELECT FROM dittmli WHERE LEFT(dittmli.mdate, 6) = '".$tab."' union SELECT from cal_main WHERE LEFT(cal_main.mdate, 6) = '".$tab."' order by mdate") or die(mysql_error());