Tuesday, 17 September 2013

mysql query on left join where multiple value

mysql query on left join where multiple value

Here is my sql data fiddler http://sqlfiddle.com/#!2/63178/1 wats wrong in
my query please help.
SELECT DISTINCT curr.id,curr.curr_tittle, curr.curr_desc
FROM wp_curriculum curr LEFT JOIN (SELECT DISTINCT * FROM
wp_curriculum_topic WHERE curr_topic IN (4,12)) AS A ON A.curr_id =
curr.id ORDER BY A.id

No comments:

Post a Comment