Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: problem making subquery

    hi, im trying to make a subquery with MySQL 4.0.15.

    it goes like this:

    this query works fine:

    SELECT MAX(unitprice)
    FROM tblproducts;


    This query also works fine:

    SELECT productid,productname,unitprice
    FROM tblproducts
    WHERE unitprice = 271;


    This query doesnt work:

    SELECT productid,productname,unitprice
    FROM tblproducts
    WHERE unitprice = ( SELECT MAX(unitprice) FROM tblproducts );

    it gives me this error:
    Error Code : 1064
    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT MAX(unitprice) FROM tblproducts )' at line 3


    Can someone please help me?! thanks in advance.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    subqueries are not supported until 4.1

    try this --
    Code:
    select productid
         , productname
         , unitprice 
      from tblproducts
    order 
        by unitprice desc
    limit 1
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •