MySQL join problem

Posted by snaken on Stack Overflow See other posts from Stack Overflow or by snaken
Published on 2010-05-17T14:36:26Z Indexed on 2010/05/17 14:41 UTC
Read the original article Hit count: 215

Filed under:
|

Whats wrong with this SQL? It should return results but returns nothing

SELECT `pid` FROM `products` 
LEFT JOIN `prods_to_features` 
ON (`ptf_pid` = `pid`) 
WHERE (`ptf_id` = '66' OR `ptf_id` = '67') 
AND (`ptf_id` = '76')

Is it not possible to have the 2nd where clause for the table that has been used in the left join?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about sql