Database: customers_and_invoices
Question: What are the invoice dates, order ids, and order 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