>Hi,
> I would like to combine 2 tables (with same structure) and remove duplicate record after query. How could I do so?
>
> I try :
> SELECT DISTICNT Card_ID, Status, Date FROM
> (SELECT * FROM Table1 UNION SELECT * FROM Table2)
>
>Any Suggestion?
Actually,
SELECT * FROM Table1 UNION SELECT * FROM Table2
is enough, because UNION does Distinct by default (which wasn't what I wanted in some cases, and took me some while to find out).