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