select distinct A.A_id,A.A_name from Artist A join Songs B on A.A_id=B.Aid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)