Re: Nested SQL query involving multiple tables!

On Jan 23, 4:47 pm, "gazzag" <gar..._at_jamms.org> wrote:
> qazmlp1..._at_rediffmail.com wrote:
> > have two tables:
> > Table-1, with the columns Col-a1, Col-b1 and some other columns
> > Table-2, with the columns Col-a2, Col-b2, Col-c2 and some other[deletia]
>
> > I tried with some queries, but I get errors like "single-row subquery returns more
> > than one row". Hence, I require your help.If you post some examples of what you've tried, I'm sure people would
> be more inclined to help.
>
> HTH
>
> -g

I don't think the OP tried at all. He merely want someone else to do his homework.
Just look at the quick sucesssion in which he is posting elementary questions, on which he obviously didn't do anything to resolve them himself.
Probably OTS is too slow for him, so that is the reason why he is posting this here.

-- 
Sybrand Bakker
Senior Oracle DBA