Orphan Order Lines
Easy
Data Quality Checks
Return the line ids whose order_id does not exist in Orders.
Table schema
Orders(id INT PRIMARY KEY)
OrderLines(id INT PRIMARY KEY, order_id INT)Sample data
Orders
id
1
2
OrderLines
id | order_id
10 | 1
11 | 2
12 | 3
13 | 4
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.