例如:逗号分隔,拼接字符串
select group_concat(payDef.NODEDESC)
from tbcooperationinvoiceinfo coop LEFT JOIN tbcodetypedef payDef ON coop.paytype = payDef.NODECODE and payDef.CODETYPE = ‘PAYTYPES’
希望所写的对你们有用。
例如:逗号分隔,拼接字符串
select group_concat(payDef.NODEDESC)
from tbcooperationinvoiceinfo coop LEFT JOIN tbcodetypedef payDef ON coop.paytype = payDef.NODECODE and payDef.CODETYPE = ‘PAYTYPES’
希望所写的对你们有用。