create view table_dgd0622 as select ROW_NUMBER OVER ORDER BY aid AS dgd_id a bid as mxid bmainid bwlbh bpm bggcz bdw bsl bdj bsl1 bje bbz bdj2 bdw1 bqgdh bbjjg bprdh bcgjsqgdsj bprbhfz from formtable_
可能的原因是在最后一列的语句中,多了一个逗号,应该将其删除。正确的语句应该为:
create view table_dgd0622 as select ROW_NUMBER() OVER (ORDER BY a.id) AS dgd_id, a.*, b.id as mxid, b.mainid, b.wlbh, b.pm, b.ggcz, b.dw, b.sl, b.dj, b.sl1, b.je, b.bz, b.dj2, b.dw1, b.qgdh, b.bjjg, b.prdh, b.cgjsqgdsj, b.prbhfz from formtable_main_43 a LEFT join formtable_main_43_dt1 b on a.Id=b.mainid
原文地址: https://www.cveoy.top/t/topic/hlaZ 著作权归作者所有。请勿转载和采集!