oracle - Same SQL not ending properly -


i having trouble same ora-00933. code below:

select cu.customername customer cu cu.customerid = salestranscation.customerid , salestransaction.tid = soldvia.tid , soldvia.productid = product.productid product.productprice >= 150; 

essentially trying collect customers bought product greater or equal 150.

thanks

i think missing and in clause query should be:

select cu.customername customer cu cu.customerid = salestranscation.customerid , salestransaction.tid = soldvia.tid , soldvia.productid = product.productid , product.productprice >= 150; 

Comments

Popular posts from this blog

python - Setting ctypes.Structure default values -

javascript - Hide toolbar of pdf file opened inside iframe using firefox -

google chrome devtools - How to show mouse pointer in responsive mode? -