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
Post a Comment