1) you can use plurals, so "select from orders" 2) typically there is no single order table. Most systems will have order_summary / order_details / order_items

1) you can use plurals, so "select from orders" 2) typically there is no single order table. Most systems will have order_summary / order_details / order_items / order_packages . Think of handling a single order that has multiple products each of multiple quantities. And to complicate, fulfillment of product quantity requires multiple warehouses / shipments. 3) you can have a table called order, you just have to ensure to escape it properly, either double quotes or square brackets. Similarly table names can have spaces in them.