mysql - 如何为下表编写sql查询

Question

我有一个名为“invoice”的表，它由列名“CId”组成

我有另一个名为 invoiceclient_details 的表，它由列名“CId”组成

所以现在我的问题是“我应该写什么查询才能得到更大“CId”的数据，即包含更大“CID”的数据行

我试过这样

SELECT
invoiceclient_details.OrganizationName,
invoiceclient_details.InvoiceNo,
invoiceclient_details.InvoiceDate,
invoiceclient_details.DeliveryNote,
invoiceclient_details.TermsofPayment,
invoiceclient_details.EsugamNo,
invoiceclient_details.OrganizationName,
invoiceclient_details.BuyerOrderNo,
invoiceclient_details.BuyDate,
invoiceclient_details.DispatchDocumentNo,
invoiceclient_details.Dated,
invoiceclient_details.DispatchThrough,
invoiceclient_details.Destination,
invoiceclient_details.TermsofDelivery,
invoiceclient_details.BuyerTin,
invoice.id,
invoice.DescriptionOfGoods,
invoice.Quantity,
invoice.PerUnitPrice,
invoice.TotalPrice,
invoice.VAT14,
invoice.VAT5,
invoice.ServiceTax,
invoice.CST
FROM invoiceclient_details,invoice
WHERE MAX(invoiceclient_details.CId) = MAX(invoice.CId);

但是它显示了类似

的错误

"misusage of group function"

Answer 1

使用 INNER JOIN 连接 CId 上的表。

SELECT *
FROM invoice i
INNER JOIN invoiceclient_details icd ON i.CId = icd.CId