I have 2 table A and B.

Table A is use for recording master data
Table B is use for recording transaction

example:

Table A
-------------------
Code | Description
-------------------
0001 John
0002 Mary
-------------------

Table B
--------------------------------------
Code | Date | Transaction
--------------------------------------
0001 | 01-01-2008 | Transaction John 1
0001 | 01-02-2008 | Transaction John 2
0001 | 01-03-2008 | Transaction John 3
0002 | 01-01-2008 | Transaction Mary 1
0002 | 15-02-2008 | Transaction Mary 2
--------------------------------------

Now I want to get record from Table A and Table B and get only the last transaction of each Code, like this:


----------------------------------------------------
Code | Description | Date | Transaction
----------------------------------------------------
0001 | John | 01-03-2008 | John Transaction 3
0002 | Mary | 15-02-2008 | Mary Transaction 2
----------------------------------------------------

Can anyone teach me how to use Transact-SQL command to get result like that?

Thanks,

Ongky


New Email addresses available on Yahoo!
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/