Based on the solution you provided to me, I've done some reading and trying. I understand there are some benefits in using joins instead of the where clause (like smaller...

Many thanks! I tried this and it gives exactly the results I was looking for! I think I now need to put a lot of effort in better learning working...

Thanks for your comments. LastUpdatedOn is not a datetime field, but I know what you mean. In other scripts with dateadd functions I noticed this gives problems with datetime fields....

Thanks people. With the help of your comments I solved this. The code you showed me is much more readable than my own way, I will definitely use this for...

Yes I tried not to select NULL-values, but I think I explained the problem wrong. The column ProdStatusLog.LastUpdatedOn doesn't contain NULL values, but when I execute the statement, all values...