Thank you Martin for the quick reply, rage is acting like OR condition instead of AND condition, used the same query(as u mentioned) Line no 5 and 6 it is not displaying can you pls help attached below screenshot after executing the query
Your own screenshot disproves your theory too - the SQL statement contains AND operator, not OR. Also, the data corresponds to what you asked for.
You want to show only lines that have status “Open order” and no GSID. Line 5 isn’t shown because GSID isn’t empty. And line 6 isn’t shown because it doesn’t have the correct status.
If you want to see lines 5 and 6, you seem to want the opposite of what you’re claiming. It seems that you actually want lines that either has “Open order” status OR they have no GSID.