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.