just a general comment in regards to syntax. You gave the following code snippet as a shortcut for when you are doing table joins:

and p.productkey = oi.productkey

and p.usprice =...