Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!cs.utexas.edu!samsung!uunet!munnari.oz.au!bruce!monu1!monu6!edd842c
From: edd842c@monu6.cc.monash.edu.au (j.e. 8842141 osborn)
Newsgroups: comp.databases
Subject: Multiple selects
Message-ID: <1990Oct4.072314.27476@monu6.cc.monash.edu.au>
Date: 4 Oct 90 07:23:14 GMT
Organization: Caulfield Campus, Monash University, Melb., Australia.
Lines: 34


I have a  question which I am sure is a very easy one
to solve and is solved often - but being a student using
INFORMIX for an industrial experience project, I haven't
had much time to get an in-depth knowledge of SQL.

Here's the problem ->

I want to have a select statement such as :

Select * from supp
   where supp_nbr =

      select supp_nbr from quote
     	  where quote_nbr =

			   select quote_nbr from quote_line
				  where quote_line.stk_no = p_stk_no

ie I want to return all of the suppliers who have quoted for
a certain stock item.

The problem is that the two innermost selects can return multiple
rows.

Is the problem as simple as declaring cursors for the innnermost 
select statements ????

I'd be happy for some advice .....                  


/////////////////////////////////////////////////////////////
Jamie Osborn                  edd842c@monu6.cc.monash.edu.au
/////////////////////////////////////////////////////////////