Database: advertising_agencies
Question: Show all agency ids and details for agencies with a client.
SQL:
SELECT T1.agency_id ,  T1.agency_details FROM Agencies AS T1 JOIN Clients AS T2 ON T1.agency_id  =  T2.agency_id