mysql ²éѯ¶àÌõ½á¹û,ºÏ²¢³ÉÒ»¸ö½á¹û,ʹÓà group_concat()º¯Êý

¿ªÊ¼²éѯµÄ½á¹ûsql

SELECT EMPLOYEE_NAME FROM MST_EMPLOYEE EM JOIN P_PROEMPLOYEE PRO ON PRO.PE_EID = EM.EMPLOYEE_ID AND EM.EMPLOYEE_DELFLG = '1'


AND EM.EMPLOYEE_STATUSID <> '1' JOIN P_PROJECT P ON P.PRO_RESID = PRO.PE_PROID AND P.PRO_DELFLG = '1' WHERE PRO.PE_PROID ='64-11181144727'

ʹÓÃgroup_concat()º¯Êý²éѯÐ޸ĺóµÄ½á¹û:

select (

select group_concat(EMPLOYEE_NAME) from MST_EMPLOYEE EM, P_PROEMPLOYEE PRO,P_PROJECT P WHERE PRO.PE_EID = EM.EMPLOYEE_ID AND EM.EM PLOYEE_DELFLG = '1'

AND EM.EMPLOYEE_STATUSID <> '1' AND P.PRO_RESID = PRO.PE_PROID AND PRO.PE_PROID = '64-11181144727'

) as AVALUE from MST_EMPLOYEE limit 1;

±ÈÈ翪ʼ²éѯµÄ½á¹ûΪ

EMPLOYEE_NAME

ÕÅÈý

ÀîËÄ

ÍõÎå

ÔòÐ޸ĺó²éѯµÄ½á¹û¼¯Îª:

EMPLOYEE_NAME

ÕÅÈý,ÀîËÄ,ÍõÎå