Hi,
Thank you for your reply. I have tried the SQL Statement. I does great but there are some duplicated record ... as the following
Table1
Date ABal
01/01/2000 1000
02/01/2000 500
Table2
Date BBal
01/01/2000 800
03/01/2000 1500
Result
Date ABal BBal
01/01/2000 1000 ****
01/01/2000 800 ****
02/01/2000 500
03/01/2000 1500
My Expected Result
Date ABal BBal
01/01/2000 1000 800 ****
02/01/2000 500
03/01/2000 1500
Any idea?
Thank you
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...