Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. FROM INVOICE_LINE T1
  2. WHERE T1.INVOICE_ID AND T1.LINE
  3. NOT IN (SELECT T2.INVOICE_ID,T2.LINE
  4. FROM INVOICE_LINE2
  5. WHERE T1.INVOICE_ID = T2.INVOICE_ID
  6. AND T1.LINE = T2.LINE
  7. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement