17,382
社区成员




SELECT
C.CUST_ID,C.CUST_NAME,S2.PVI,S3.PUI_NBR
FROM CUST C,SERV_SERVICE S1,SERV_PVI S2,SERV_PUI S3
WHERE C.CUST_ID=S1.CUST_ID
AND S1.SERV_SERVICE_ID=S2.SERV_SERVICE_ID
AND S1.SERV_SERVICE_ID=S3.SERV_SERVICE_ID
AND S1.STATE='S11'
AND C.CUST_NAME LIKE '韩永佳%';
SELECT C.CUST_ID,C.CUST_NAME,S2.PVI, WM_CONCAT(S3.PUI_NBR) AS PUI_NBRS
FROM CUST C,SERV_SERVICE S1,SERV_PVI S2,SERV_PUI S3
WHERE C.CUST_ID=S1.CUST_ID
AND S1.SERV_SERVICE_ID=S2.SERV_SERVICE_ID
AND S1.SERV_SERVICE_ID=S3.SERV_SERVICE_ID
AND S1.STATE='S11' AND C.CUST_NAME LIKE '韩永佳%'
GROUP BY C.CUST_ID,C.CUST_NAME,S2.PVI;