SubQueries
Posted by: prem anand
Date: January 19, 2005 04:05AM

Hi,I'am prem.i Have a problem in subqueries.I need an solution can anyone drag me out from this problem
My Problem is :
I have three field like a)SCDate b)Buyercode c)Buyername and my table name is SOFOM.

i wrote a query like this

"select Buyername from SOFOM where Buyername =
(select Buyername from SOFOM where Buyercode=
(select Buyercode from SOFOM where SCDate>='2004-01-01' and SCDate <='2004-12-31'))";

but its showing me error in (select Buyername from SOFOM where Buyercode=
(select Buyercode from SOFOM where SCDate>='2004-01-01' and SCDate <='2004-12-31'))"; these lines i don't know whats the reason.

can anyone help me out to get rid of this problem

Options: ReplyQuote


Subject
Written By
Posted
SubQueries
January 19, 2005 04:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.