Hi..
i want to get all columns from tbl_class where course_id of tbl_course is equal to course_id of tbl_class more over course_id of tbl_course should be thw one who has semester = 5
brife structure of tables are:
tbl_class
class_id
course_id
class_room
tbl_course
course_id
semester
i have design this kind of querry logicaly as m not good in sql but it doesnt work it return multiple values from subquerry that is i am getting 2 course ids now i want * from tbl_class where course_id = result by subquerry
SELECT *
FROM tbl_class
WHERE course_id = (SELECT course_id FROM tbl_course WHERE semester = '5')
thanks