Hi,
i would like to check corresponding fields from 2 seperated tables:
tblVolumeNames
VolumeNameID VolumeName
1 Vol1
2 Vol2
3 Null (blank)
4 Vol3
Temp_VolumeChanges
ID VolumeName Name
1 Vol1 Paul
2 Null (blank) Jacek
3 Null (blank) John
I want to check which volumeName is present in Temp_VolumeChanges and is NOT present in tblVolumeNames table.
So i created sql like here:
This result should show nothing (because null exists also in tblVolumeNames) but i am getting:
Why is that?
What can i do to avoid this?
Please help,
Jacek
i would like to check corresponding fields from 2 seperated tables:
tblVolumeNames
VolumeNameID VolumeName
1 Vol1
2 Vol2
3 Null (blank)
4 Vol3
Temp_VolumeChanges
ID VolumeName Name
1 Vol1 Paul
2 Null (blank) Jacek
3 Null (blank) John
I want to check which volumeName is present in Temp_VolumeChanges and is NOT present in tblVolumeNames table.
So i created sql like here:
Code:
SELECT t2.VolumeName
FROM Temp_VolumeChanges AS t2 LEFT JOIN tblVolumeNames AS t1 ON Nz(t2.VolumeName,"Null") = Nz(t1.VolumeName,"Null")
WHERE t1.VolumeName) Is Null;
This result should show nothing (because null exists also in tblVolumeNames) but i am getting:
Why is that?
What can i do to avoid this?
Please help,
Jacek