Recently I tried many ways to retrive two columns from database.
First I'll explain my database structure:
I want to retrive mod_id,name from module table.
I used this select query to do that :
select md.mod_id as 'mdid',md.name as 'nme' from module md,lesson ls where md.mod_id=ls.mod_id and ls.semester='1' and ls.faculty='School of Computing' and ls.year='1'
But results should be
please help me to correct this wrong. I'm stucked....