Kind of off topic, but yes, you do want to do the joins in the join clause. I was shooting for a simple example, but in reality I'd probably have a snippet of
inner join orderitem oi
on p.productkey = oi.productkey
inner join price p
on p.usprice = oi.usprice
inner join orderstaken o
on oi.orderid = o.orderid
inner join customers c
on o.customerid = c.customerid
Steve Jones