我有一个连接多个表的查询,所有这些表都有一个名为businessetityid.So的列,该列复制了许多times.Is --任何简单的处理方法。以下是我的疑问:inner join personemailaddress e on p.BusinessEntityID=e.BusinessEntityIDinner join personphone ph on p.BusinessEntityID=ph
我有一个输出如下的查询: select c.case_id caseId, c.memberId memberId, c.last_name lastName, c.first_name firstName, lkp_alt.descr altShowCauseAuthority, listagg(lkp_cs.descr,',') within group (order by lkp_cs.id) as caseStatus
from cases c join lkP_alt_show_cause_auth