NYCPHP Meetup

[Phil Powell]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030921/d58343ca/attachment.html>