ail.com]
Sent: 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
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 wrote:
> Hi
>
> I have 2tables. 1
