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?
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...