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-11 : 01:45:58
|
my query is Select gam.acct_name,gam.cif_id,gam.schm_code,(select gam.foracidFrom TBAADM.GAMWhere gam.acid In (Select gam.acid From tbaadm.gam, tbaadm.tamWhere GAM.acid = TAM.repayment_acid)) table1from tbaadm.gamwhenn i am executing this it shows the error of ORA-01427: single-row subquery returns more than one i want to show gam.acct_name,gam.cif_id,gam.schm_code and gam.foracid Based on GAM.acid =GAC.int_cr_acidplease provide a solution of given query thanks in advanceVipin jha |
|
lionofdezert
Aged Yak Warrior
885 Posts |
|
|
|
|