NYCPHP Meetup

[Anthony]

You wrote:

=================================
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
============================================================
Just got back from holiday, hence late reply. Didn't you just miss out an
underscore at the end of the line:

"WHERE s.nnet_produkt_storrelse.id = sv.nnet_produkt_storrelse id"

I usually look twice when I find myself blaming a language or system :D

Cheers...
_________________________________________________________
This mail sent using V-webmail - http://www.v-webmail.org