This Query can be replaced by which one of the following ?
A. Select name,course_id from teaches,instructor where instructor_id=course_id;
B. Select name, course_id from instructor natural join teaches;
C. Select name ,course_id from instructor;
D. Select course_id from instructor join teaches;
Answer:A
This Query can be replaced by which one of the following ?
A. Select name,course_id from teaches,instructor where instructor_id=course_id; B. Select name, course_id from instructor natural join teaches; C. Select name ,course_id from instructor; D. Select course_id from instructor join teaches;
Explanation:Join clause joins two tables by matching the common column . 7. Select * from employee where salary>10000 and dept_id=101;