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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
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.
Then I’d guess your joins are wrong.