Database: advertising_agencies
Question: What are the client details for each client and the corresponding details of their agencies?
SQL:
SELECT T1.client_details ,  T2.agency_details FROM Clients AS T1 JOIN Agencies AS T2 ON T1.agency_id  =  T2.agency_id