显示Track表中没有发票的所有记录-比较两个表

Question

强调文本第一个表为Track，第二个表为InvoiceLine。它们都共享"InvoiceId"列。我试着:

SELECT *
FROM Track
WHERE NOT EXISTS (
    SELECT *
    FROM InvoiceLine
    WHERE InvoiceId )

Answer 1

SELECT T.* 
FROM TRACK AS T
WHERE NOT EXISTS
(
   SELECT 1 FROM INVOICELINE AS L
   WHERE T.INVOICEID=L.INVOICEID
)