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-09 : 02:18:29
|
| 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.tam Where 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 |
|
|
ms65g
Constraint Violating Yak Guru
497 Posts |
Posted - 2011-04-09 : 02:22:58
|
| What RDBMS are you using?______________________ |
 |
|
|
vipin_jha123
Starting Member
31 Posts |
Posted - 2011-04-09 : 03:23:23
|
| sql |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-11 : 08:23:53
|
| 100% its ORACLE--------------------------http://connectsql.blogspot.com/ |
|
|
|
vipin_jha123
Starting Member
31 Posts |
Posted - 2011-04-12 : 01:22:26
|
| yaya sorry thats oracle |
|
|
|
|
|
|
sql query error