Database: book_1
Question: What are the ids of all orders and the corresponding client names?
SQL:
SELECT T1.idOrder ,  T2.name FROM Orders AS T1 JOIN Client AS T2 ON T1.idClient  =  T2.idClient