I think that you can do what you want with a simple union query:
select * from incoming where user_id = 123
union
select * from outgoing where user_id = 123
order by datetime_received, datetime_sent
hth,
Arthur
On Wed, Sep 23, 2009 at 10:02 AM, Warren Windvogel war...@fontera.comwrote:
Hi
I
: 23 September 2009 15:42
To: mysql@lists.mysql.com
Subject: Re: Retrieving info from 2 tbls ordering it
I think that you can do what you want with a simple union query:
select * from incoming where user_id = 123
union
select * from outgoing where user_id = 123
order by datetime_received