mysql区分查询或分组查询

Question

我有以下问题：-

Select
  PUB.oa_inthed.adcode As Address_Code,
  PUB.oa_intnom."due-date" As Commitment_Due_Date,
  PUB.oa_inthed.company As Company,
  PUB.oa_intnom.costcentre As Cost_Code,
  PUB.oa_inthed.currency As Currency,
  PUB.oa_inthed.description As Description,
  PUB.oa_inthed.docdate As Document_Date,
  PUB.oa_inthed."doc-id" As Document_Type,
  PUB.oa_intnom.expensecode As Expense_Code,
  PUB.oa_inthed.intid As Interface_Record_Key,
  PUB.oa_inthed.posted As "Posted?",
  PUB.oa_inthed.srcaccount As Source_Account,
  PUB.oa_inthed.docval As Value_Cur,
  PUB.oa_inthed.period As Period,
  PUB.oa_inthed.stat As Status
From
  PUB.oa_inthed Inner Join
  PUB.oa_intnom On PUB.oa_intnom.intid = PUB.oa_inthed.intid Inner Join
  PUB.oa_intextra On PUB.oa_intextra.intid = PUB.oa_intnom.intid
Where
  PUB.oa_inthed.company = 01 And
  PUB.oa_inthed.intid = 'XM618197%' And
  PUB.oa_intextra.rectype = 'REQHEAD'

并返回以下数据：

​

​

我如何才能为每个信息获得一个明确的行？

我正在使用MySQL。

欢迎所有建议

Answer 1

试试这个(未经测试)：

SELECT PUB.oa_inthed.intid, 
    PUB.oa_inthed.adcode As Address_Code, 
    PUB.oa_intnom."due-date" As Commitment_Due_Date,
    PUB.oa_inthed.company As Company,
    PUB.oa_intnom.costcentre As Cost_Code,
    PUB.oa_inthed.currency As Currency,
    PUB.oa_inthed.description As Description,
    PUB.oa_inthed.docdate As Document_Date,
    PUB.oa_inthed."doc-id" As Document_Type,
    PUB.oa_intnom.expensecode As Expense_Code,
    PUB.oa_inthed.posted As "Posted?",
    PUB.oa_inthed.srcaccount As Source_Account,
    PUB.oa_inthed.docval As Value_Cur,
    PUB.oa_inthed.period As Period,
    PUB.oa_inthed.stat As Status
FROM PUB.oa_inthed
INNER JOIN PUB.oa_intnom 
ON PUB.oa_intnom.intid = PUB.oa_inthed.intid 
INNER JOIN PUB.oa_intextra 
ON PUB.oa_intextra.intid = PUB.oa_intnom.intid
INNER JOIN (
    SELECT PUB.oa_inthed.intid
    FROM PUB.oa_inthed
    GROUP BY PUB.oa_inthed.intid
) AS _aa
ON PUB.oa_inthed.intid = _aa.PUB.oa_inthed.intid
WHERE PUB.oa_inthed.company = 01 AND PUB.oa_inthed.intid = 'XM618197%' AND PUB.oa_intextra.rectype = 'REQHEAD'