Show invoice dates and order id and details for all invoices.
create table invoices (invoice_date varchar, order_id varchar, PRIMARY KEY (invoice_date)); create table orders (order_details varchar, order_id varchar, PRIMARY KEY (order_details))
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