Dear All,

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