NYCPHP Meetup

[Phil Powell]

I'm not kidding, the only reason yesterday you didn't hear from me was because I wasn't coding, but today I am doing something quick, and yes, as always it failed.. right at the SQL statement:


   $sql = 'SELECT v.nnet_produkt_varegruppe_navn, ' .
          '       f.nnet_produkt_farge_navn, ' .
          '       s.nnet_produkt_storrelse_navn, ' .
          '       k.nnet_produkt_kvalitet_navn, ' .
          '       p.* ' .
          'FROM nnet_produkt p, nnet_produkt_varegruppe v, ' .
          '     nnet_produkt_kvalitet k, nnet_produkt_storrelse s ' .
          'WHERE p.nnet_produkt_varegruppe_code = v.nnet_produkt_varegruppe_code ' .
          ' AND p.nnet_produkt_farge_code = f.nnet_produkt_farge_code ' .
          ' AND p.nnet_produkt_storrelse_id (+) = s.nnet_produkt_storrelse_id ' .
          ' AND p.nnet_produkt_kvalitet_id (+) = k.nnet_produkt_kvalitet_id';

I am getting "invalid SQL near (+).  That is totally VALID SQL syntax for an outer join!  If mySQL doesn't allow for that, what am I supposed to do in lieu of the fact that I have to logically join two tables together or if the one is null (the case for an outer join)?

Phil
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030912/b491c580/attachment.html>