oracle 数据库 建立视图 时 提示
ORA-00936：missing expression
ORA-06512:at line 1
create or replace force view V_contestSell
as
select A.uuid,A.unitId,A.sellDate,A.interval,A.shopId.A.remark,A.createTime,A.updateTime,A.operator,
B.productId ,B.amount,price, B.amount*B.price as total,B.spscale,B.lremark,
c.shopType,c.sellChannel,c.areaId,d.productType,d.productBrand,
from B_sellerAndContest A join b_cplist B on A.uuid=B.contestId
left join B_OtherSeller c on A.uuid=c.shopId
left join B_Contest d on B.productId=d.uuid;
请高手解答在线等
------解决方案--------------------
SQL语句问题。。。。似乎不能连续JOIN。。。
------解决方案--------------------
c.shopType,c.sellChannel,c.areaId,d.productType,d.productBrand,
from B_sellerAndContest A join b_cplist B on A.uuid=B.contestId
d.productBrand,
这多了个逗号吧