join problem
Posted by:
clips
Date: May 13, 2005 01:49AM
Hi , I've a little problem: if I' ve the table:
Tab1(A, mydate)
-----------------------
mike , 12-04-1975
jhon , 5-11-1982
Tab2(B, mydate)
----------------------------
red , 14-09-1981
yellow , 27-02-2004
I'm looking for a MySQL query that return
TabOutput (A, B, mydate)
--------------------------------
null , yellow , 27-02-2004
jhon , null , 5-11-1982
null , red , 14-09-1981
mike , null , 12-04-1975
order by mydate
Can you help me? Thanks
Subject
Written By
Posted
join problem
May 13, 2005 01:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.