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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 sql qyery output

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.foracid
From TBAADM.GAM
Where gam.acid In (Select gam.acid From tbaadm.gam, tbaadm.tam
Where GAM.acid = TAM.repayment_acid)) table1
from tbaadm.gam

whenn 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_acid
please provide a solution of given query

thanks in advance

Vipin jha

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-04-11 : 05:28:36
Duplicate post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=159283

--------------------------
http://connectsql.blogspot.com/
Go to Top of Page
   

- Advertisement -