I'm trying to figure out how to combine these two tables. I have.. t1 date accidentInfo cost
t2 date upgradeInfo whereUpgraded Salesman cost I want to combine the two in a way to reference each piece of data such as t1.accidentInfo,t2upgradeInfo and so on, but I need the resultset to be ordered by the combined dates. If I do order by t1,t2 I get the t1 in order by date then the t2 so I don't see how to combine them. I understand that a union would put the dates under the same column but it looks like it also puts accidentInfo and upgradeInfo under the same column too. Can someone help me see the light here? Larry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]