Menna mage answer ek select student_name from student where student_id not in (select student_id from student_marks where subject_id in (select subject_id from subjects where subjects in ("Maths","Science"))); meken niwaradi pilithura enwa. Mm waradi nm kiyanna (not ek enna ona mehema -> "student_id not in " . nathuwa mehema nemei -> "subjects not in" )
software field එකේ ඔයාලට තියෙන ඕනම ප්රශ්නයක් ගැන discuss කරන්න අපේ private FB group එකට join වෙන්න..
facebook.com/groups/lankadroid/
ගොඩක් හොදට තෙරෙනවා අයියා කියල දෙනවා.😍😍😍 මේ වෙනකන් දැනගෙන හිටියෙ නැති ගොඩක් දේවල් ඉගන ගත්තා. ගොඩක් පිං අයියේ.❤️❤️❤️🙏🙏🙏
Thank you
බොහොම ස්තූතියී 🙏
ty
Thank you very much
goods lessons...thanks
deweni prashne podi awlk thiyenwa neda oya karapu widiye
eeke ahanne maths hari science hari nokarapu arya gana
eeth oya sort out karala gnne maths and science subject_id deka arenna anith subject_id thiyena ayage wistara
example:- student 2 maths karala thiyenwa. ehenm eyage id num ek video ek awasane thiyena deweni table eke thiyenna ba. eeth thiyenwane.
Menna mage answer ek
select student_name from student where student_id not in (select student_id from student_marks where subject_id in (select subject_id from subjects where subjects in ("Maths","Science")));
meken niwaradi pilithura enwa.
Mm waradi nm kiyanna (not ek enna ona mehema -> "student_id not in " . nathuwa mehema nemei -> "subjects not in" )