NYCPHP Meetup

[Jim Hendricks]

You are probably using an older version of mysql which does not support subqueries.  You need to either move up to the latest version of mysql which I beleive now supports subqueries, or rewrite out the subquery.

Jim
______________________________________________________________
Jim Hendricks, President, Biz Computing, Inc
Phone:  (201) 599-9380     Email: jim at bizcomputinginc.com
Web: www.bizcomputinginc.com 
Snail:  Jim Hendricks,  Biz Computing, Inc.,  255 McKinley Ave, New Milford, NJ 07646
______________________________________________________________

  ----- Original Message ----- 
  From: Phil Powell 
  To: NYPHP Talk 
  Sent: Sunday, September 21, 2003 12:53 PM
  Subject: [nycphp-talk] Error involving inner SELECT using mySQL - HELP


  Ok guys, here we go again!

  SELECT s.nnet_produkt_storrelse_navn 
  FROM nnet_produkt_storrelse s, nnet_produkt_varegruppe v, nnet_storrelse_varegruppe_assoc sv 
  WHERE s.nnet_produkt_storrelse.id = sv.nnet_produkt_storrelse id 
   AND sv.nnet_produkt_varegruppe_id = v.nnet_produkt_varegruppe_id 
   AND sv.nnet_produkt_varegruppe_id IN (
     SELECT nnet_produkt_varegruppe_id 
     FROM nnet_produkt_varegruppe
     WHERE nnet_produkt_varegruppe_code =  'FLU17' 
   )
   AND s.nnet_produkt_storrelse_id > 1

  This produces the following error:

  You have an error in your SQL syntax near 'id AND sv.nnet_produkt_varegruppe_id = v.nnet_produkt_varegruppe_id AND sv.nnet_' at line 1

  I don't see anything wrong with this query, it's standard inner SELECT stuff!  I need help... again!

  Phil


------------------------------------------------------------------------------


  _______________________________________________
  talk mailing list
  talk at lists.nyphp.org
  http://lists.nyphp.org/mailman/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030921/89cc364b/attachment.html>