Transposing rows to columns

From: <pallavi.jayanti_at_gmail.com>
Date: 24 Jul 2006 10:19:34 -0700
Message-ID: <1153761574.725838.272020@h48g2000cwc.googlegroups.com>

Dear readers,

I have data in 2 tables in the following manner:

Table A:

Source_Code           BU_SET_ID        Account_Number
ALS                       3                     1415999
ALS                       1                     1415999

Table B:

BU_SET_ID                  BU_type                   BU_Code
1                           LOB                       TEST
3                           REICO                    SURP

I need the o/p to look like:

Source_Code       Account_Number         LOB                REICO
ALS                      1415999                   TEST

SURP Any help is appreciated. Received on Mon Jul 24 2006 - 12:19:34 CDT