Database: customers_and_invoices
Question: Show invoice dates and order id and details for all invoices.
SQL:
SELECT T1.invoice_date ,  T1.order_id ,  T2.order_details FROM Invoices AS T1 JOIN Orders AS T2 ON T1.order_id  =  T2.order_id