17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT t3.xzqdm,
t.c_zqcode
FROM gdlyjc.fl_sys_lqzqzd t,
LBMS_LQJFJL t2,
(SELECT SUBSTR(t3.SQBBH,0,9) AS xzqdm, sllmldzkdjb_bh FROM LBMS_SLLMLDZKDJB
) t3
WHERE t.c_zqcode =t3.xzqdm
AND t2.sllmldzkdjb_bh = t3.sllmldzkdjb_bh
GROUP BY t3.xzqdm,
t.c_zqcode