You need UNION not JOIN

SELECT dateField FROM table1 ;
UNION ;
SELECT dateField FROM table2 ;

>I have 2 tables.
>
>Table1
>

>2006-01-01
>2006-01-01
>2006-01-01
>2006-02-01
>2006-02-01
>2006-02-01
>2006-02-01
>2006-03-01
>2006-03-01
>

>
>Table2
>

>2006-01-01
>2006-01-01
>2006-02-01
>2006-03-01
>2006-03-01
>2006-04-01
>

>
>I want to use join statement in SQL select to Output like this:
>Output table
>

>2006-01-01
>2006-02-01
>2006-03-01
>2006-04-01
>

>
>I have tried to use INNER JOIN & OUTER JOIN & LEFT JOIN, none are working... Any idea?!
>

>SELECT distinct a.tx_date FROM tx1 a inner JOIN (select DISTINCT b.tx_date FROM tx2) b ON a.tx_date = b.tx_date INTO cursor tmp
>