无法以与数据库无关的方式来执行此操作。因此,您需要像这样获得整个数据集:
select
r.name as ResName,
a.name as AppName
from
Resouces as r,
Applications as a,
ApplicationsResources as ar
where
ar.app_id = a.id
and ar.resource_id = r.id
然后在按 ResName 分组时以 *__
SQL查询以返回用逗号(,)压缩的特定列的值[重复]
无法以与数据库无关的方式来执行此操作。因此,您需要像这样获得整个数据集:
select
r.name as ResName,
a.name as AppName
from
Resouces as r,
Applications as a,
ApplicationsResources as ar
where
ar.app_id = a.id
and ar.resource_id = r.id
然后在按 ResName 分组时以 *__