Can any one help me how to write query for this select
SELECT q_ar.id, q_ar.s_ar, q_ar.sura_ar, q_ar.a_ar, q_ar.ayat_ar, q_en.tr_y,
q_en.tr_p, q_en.tr_s
FROM q_ar
INNER JOIN q_en ON q_ar.s_ar = q_en.s_en
AND q_ar.a_ar = q_en.a_en ORDER BY q_ar.id
Thanks, K