Then I’d guess your joins are wrong.
ID's coming back as nulls are not appearing in my data set
I am trying to create a, intergrity check that bring back data after a record has been cancelled after a certain event. In my query. I am joining to a few tables and I can see all the old cancelled record. When I then cancel any new records, some IDs I am using for joining are returning nulls, and the record is not being picked in the new data set. I hope that made sense, Can someone help?
2 answers
Sort by: Newest
-
-
Olaf Helper 42,671 Reputation points
2024-06-19T17:17:33.9333333+00:00 In my query. I am joining to a few tables
A very theoretical query without any usefull information.
We don't have your database to test anything.
Please post table design as DDL, some sample data as DML statement and the expected result.