CODE EXAMPLE FOR SQL

join multiple tables

SELECT o.orderid, o.amount, i.description
2FROM orders o
3INNER JOIN items i
4ON o.itemid = i.itemid