JEPaas代码(SQL功能表)通过SQL功能表进行表查询
1.新建一个表单——添加功能表——在功能表配置信息中///如下:
输入相应的SQL查询语句“(在那之前通过SQLserver查询语句是否无误!)
注意点!!!SQL句中不能包含“;”,尽量避免
//###yk_ypgl
SELECT
YPMC,
TYM,
PYM,
a.DC,
a.GC,
a.STATUS,
GG,
DW,
LB,
JX,
JL,
JLDW,
b.DC,
YPLX ,
PSPB ,
GJJBYW,
JBYWLX,
ZXDW,
YFGG,
YFDW,
YFBZ,
ZXBZ,
BFGG,
BFDW,
BFBZ,
FYFS,
GYFF,
TSYP,
YPZC,
YBFL,
CFYP,
QZCL,
SFKSS,
YCYL,
KSSDJ,
DDDZ,
ID,
DRR,
DRSJ,
CJJG,
CJR,
CJSJ,
XGJG,
XGR,
XGSJ,
ZHXGR,
ZHXGSJ,
YPID,
YKID
FROM
yk_ypxx a
LEFT JOIN
xx_YP b ON a.ypid = b.YP_YPID;