Hi Guys,
i want to ask you once again about nulls in tables.
I created 2 tables:
And now i create query to check if records in TempTable exists in Target Table:
The result seems to be ok even i have nulls here.
When i am joining much more fields, like 15 like that sometimes nulls is not joined.
1. Why this is somehow randomly working and sometimes not?
2. Is is always safe to change nulls to not used values like "-199999" fornumbers or "null" for strings to be sure that this will work?
3. What are your best practices?
thank you in advance for any answer,
Best,
Jacek
i want to ask you once again about nulls in tables.
I created 2 tables:
And now i create query to check if records in TempTable exists in Target Table:
The result seems to be ok even i have nulls here.
When i am joining much more fields, like 15 like that sometimes nulls is not joined.
1. Why this is somehow randomly working and sometimes not?
2. Is is always safe to change nulls to not used values like "-199999" fornumbers or "null" for strings to be sure that this will work?
3. What are your best practices?
thank you in advance for any answer,
Best,
Jacek