multiple table inner joit didn't get expected values

Student_register table

• regNo


• pro(HNDIT,HNDA,HNDFT)


• name


• start_day

etc ... more columns

semester

• regNo


• curSemmester(3,4,5)


• name

THIS IS THE quary that i used to get values

---

SELECT student_register.pro='HNDIT', student_register.regNo,sem.curSem =4,sem.name FROM student_register INNER JOIN sem ON sem.regNo = student_register.regNo ORDER BY sem.regNo;

this is what i want to do in here i need to get regNo from student_register that according to pro = hndit or any other (hndft/HNDA) then i want to compare those regNo to current sem which that user define curSem=3 (4/5/6) regNo Numbers

simply get student numbers that who do HNDIT course and then get regNO from sem table that user define semester(3 or 4 or 5 ) student who do Course hndit

student_register.pro='HNDIT'------>sem.curSem =4---------->regNo and name