Fetch rows that are not present in another table #6711
Unanswered
harishannam
asked this question in
Question
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
How to write a GQL query for the below SQL query?
SELECT od.order_key FROM order_details od LEFT JOIN redeemed_orders ro ON ro.order_key = od.order_key WHERE ro.order_key IS NULL
This query fetches the expected results but I am not sure on how to fetch data the similar way in GQL query.
I already have an Array relationship
redemption_details . order_key → order_details . order_key
added tot heorder_details
tableBeta Was this translation helpful? Give feedback.
All reactions