|
View previous topic :: View next topic
|
| Author |
Message |
cmsmoon
New User
Joined: 17 Jun 2010
Posts: 75
Location: Chennai
|
|
|
|
Hi All,
I have a table
| Code: |
s.no name age bank acc_details
01 xxxx yy hdfc mmmm
01 xxxx yy icici nnnnn
01 xxxx yy sbi oooo
01 xxxx yy axis pppp |
I expect like the below results.. ('ie) all details come with one record with come common creteria s.no,name,age
| Code: |
s.no name age acc_hdfc acc_icici acc_sbi acc_axis
01 xxxx yy mmmm nnnnn oooo pppp |
|
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10845
Location: italy
|
|
|
|
we do not do urgent
replying is
on voluntary basis
on our own time
free of charge
to keep it short
when and if we feel like
if You have time constraints hire a paid consultant who, for the proper fee,
will be glad to adhere to Your time constraints
and finally
I wonder why it is so difficult to post to the right section of the forums
moved where it belongs ... |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
Q: Are the number and codenames of banks known up front (ie. 4 banks) and are those rows always there for all 4 banks. ?
If Yes, then it is a fairly simple JOIN
if No, then it is a fairly complicated and bad performing full outer join |
|
| Back to top |
|
|
|
|
