Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vipin_jha123
Starting Member
31 Posts |
 Posted - 2011-04-23 : 02:48:35
|
| Dear All,I awant to take below given data in select ststementcolumn 1=IF Count(AAS.acct_poa_as_rec_type ='J') >0 then "Y" else "N"column 2=CMG.cust_name = Can be fetched by GAM.cust_id=AAS.cust_id AND AAS.acct_poa_as_rec_type='J'column=3=CMG.cust_name = Can be fetched by GAM.cust_id=AAS.cust_id AND AAS.acct_poa_as_rec_type='J'on the basis of given join conditionGAM.acid = AAS.acid GAM.bank_id = AAS.bank_id GAM.cif_id = CMG.cif_id GAM.bank_id = CMG.bank_id pl;ease do the needful helpthanks in advanceregards,Vipin jha |
|
|
|
|
|
SQL QUERY ISSUE 34