Need Help with a SQL Query

I have 2 tables with the follwoing data(the colums names and the table structure are the same in both tables) Table B holds data of all the records that are already been extracted from Table A in the past. Table A displays newly added records

TABLE A

NAME    DATE in (DD/MM/YYYY)
====    ====
ABC      29/04/2008
DEF      29/04/2008
GHI      28/04/2008
KLM      27/04/2008
XYZ       04/04/2008
ZEE       28/04/2008
FEE       26/04/2008

TABLE 2

NAME    DATE in (DD/MM/YYYY)
====    ====
ABC     17/04/2008
DEF     17/04/2008
GHI     15/04/2008
KLM     14/04/2008
XYZ      04/04/2008

I want to write a select query that will give me all the newly added records in table A as well as those records where the date value of the names column in TableA are greater that those in tableB

so my query Result should return

NAME    DATE
====    ====
ABC      29/04/2008
DEF      29/04/2008
GHI      28/04/2008
KLM      27/04/2008
ZEE       28/04/2008
FEE       26/04/2008

I'm using Oracle 10G.
Start Free Trial