Is there a good resource online for learning how to define recordsets? I think I get the general principal behind SELECT, INNER JOIN, but I am unsure on the correct syntax.
Does this look correct?
SELECT *
FROM orders INNER JOIN orderdetails
WHERE orders.OrderID=orderdetails.DetailOrderID
ORDER BY orders.Office, orders.rep_First, orders.rep_last