SEO

#1 (**permalink**) 04-08-2008, 06:03 PM

Hi,

I want to achieve something of this effect, but this is obviously not
allowed is SQL.

select name from Names where yearOfBirth = 1983 AND school =
(select schoolName from Schools where state = 'NY')

This subquery will return multiple values. But I want the names of all
people who were born in 1983 and when to any school in New York. But
the name and schoolName are stored in different tables. So what is a
work-around for this?

Hope the above is not too ambiguous.

#2 (**permalink**) 04-08-2008, 06:03 PM

If the subquery will return multiple values, use IN rather than EQUALS,
i.e. "school IN ( select schoolName..."

Or use a join:

select n.name from Names n, Schools s where
n.yearOfBirth = 1983
and n.school = s.schoolName
and s.state = 'NY'

Does your database really not allow for a person potentially attending
more than one school?

#3 (**permalink**) 04-08-2008, 06:03 PM

thanks a lot. i have used IN before, but couldn't remember it when i
needed it! This was just an example that I randomly made up to put up
on use net. Help is much appreciated.

Cheers,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

simple subquery returning multiple rows quesetion