22,302
社区成员




SELECT
b.SubjectName,
a.SumPaid,
STUFF(
(
SELECT
',' + c.MenuName
FROM
bi_BillItem c
WHERE
a.BillID = c.BillID
FOR XML PATH('')
), 1, 1, ''
) AS MenuName,
a.billid
FROM
bi_Bill a,
bi_billpayment b
WHERE
a.BillID = b.BillID
AND a.BillDate = '2019-07-24 00:00:00'
AND a.BranchName LIKE '%创意城%'
AND a.BillID = '027J021-XS-190724-0002'
GROUP BY
b.SubjectName,
a.SumPaid,
a.billid
ORDER BY
a.BillID;
SELECT
b.SubjectName,
a.SumPaid,
STUFF(
(
SELECT
',' + c.MenuName
FROM
bi_BillItem c
WHERE
a.BillID = c.BillID
), 1, 1, ''
) AS MenuName,
a.billid
FROM
bi_Bill a,
bi_billpayment b
WHERE
a.BillID = b.BillID
AND a.BillDate = '2019-07-24 00:00:00'
AND a.BranchName LIKE '%创意城%'
AND a.BillID = '027J021-XS-190724-0002'
GROUP BY
b.SubjectName,
a.SumPaid,
a.billid
ORDER BY
a.BillID;