CBSE · 083Class XII · 2025Section D1 mark
Question 34iv
4 March 2025 · Computer Science (083)
(iv) (a) To display the name of all artists whose Article is Painting through Equi Join.
Answer
SELECT Name FROM Articles A1, Artists A2 WHERE A1.A_code = A2.A_code AND Article='Painting';
Explanation
Joins tables on A_Code and filters by Article type.