Database: advertising_agencies
Question: Show details for all clients and the details of their corresponding agents.
SQL:
SELECT T1.client_details ,  T2.agency_details FROM Clients AS T1 JOIN Agencies AS T2 ON T1.agency_id  =  T2.agency_id