I have an intersect query below
---------
SELECT distinct food.rating, food.foodname, food.foodid, food.pic_path, requirement.Req_Name, requirement.Req_Nik
FROM requirement INNER JOIN (food INNER JOIN req_food ON food.foodid = req_food.food_id) ON requirement.Req_Id = req_food.req_id
WHERE...