MySQL version 4.x has Subquery support.
On Fri July 4 2003 5:54 am, Nadim Attari wrote:
> From MS-SQL Server Manual:
> A subquery is a SELECT query that returns a single value and is nested
> inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another
> subquery. A subquery can be use
>From MS-SQL Server Manual:
A subquery is a SELECT query that returns a single value and is nested
inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside another
subquery. A subquery can be used anywhere an expression is allowed.
Unfortunately you do not have Sub-queries in mySQL ...
Try
are using mysql this probably won't work. I think mysql doesn't like subselects.
hth Henrik Hornemann
> -Oprindelig meddelelse-
> Fra: Jason Givhan [mailto:[EMAIL PROTECTED]
> Sendt: 3. juli 2003 22:39
> Til: [EMAIL PROTECTED]
> Emne: [PHP-DB] Re: A complex query
I’m sorry, let me clarify the problem: I have some schools with multiple
highlights. I want to search for a school that has BOTH highlights
‘Sports’ AND ‘Graduation’.
I can search for a school that has EITHER ‘Sports’ OR ‘Graduation’ using
this query:
SELECT schools.school_name, schools.sID
F
