Why does the order of the SELECT statements in the UNION affect the result?<BR><BR>This first SQL produces the result I want.<BR><BR>SELECT cat_id AS catid, manufacturer AS mfr, model, a_class_id as ...

I have heard a bit about mySQL limitations and I can't find a clear source that says that multiple joins as well as unions are supported in the 4.x releases.<BR><BR>Can someone comment on ...