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
Best regards,
Aaron Chu
********************************************************
Working with Visual FoxPro is a lot of FUN!
********************************************************
