Show invoice dates and order id and details for all invoices.
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
Show invoice dates refers to selecting invoice_date; order id refers to selecting order_id; details for all invoices refers to selecting order_details; joining invoices with orders on order_id.