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