SELECT * FROM orders INNER JOIN order_items ON order_items.order_id = orders.order_id ORDER BY order_date DESC; Code language: SQL (Structured Query Language) (sql)