Join with more than 15 fields (1 Viewer)

SELECT DISTINCT *
FROM tblVolumes AS t2 LEFT JOIN qryIm_SourceVolumes AS t1 ON (t2.PercentSnapshotSpace = t1.PercentSnapshotSpace or (t2.PercentSnapshotSpace is Null AND t1.PercentSnapshotSpace is Null)) AND (t2.FilesystemType = t1.FilesystemType or (t2.FilesystemType is Null AND t1.FilesystemType is Null)) AND (t2.DiskNumber = t1.DiskNumber or (t2.DiskNumber is Null AND t1.DiskNumber is Null)) AND (t2.VolumeNameIDFK = t1.VolumeNameIDFK or (t2.VolumeNameIDFK is Null AND t1.VolumeNameIDFK is Null)) AND (t2.PhysicalDiskModelIDFK = t1.PhysicalDiskModelIDFK or (t2.PhysicalDiskModelIDFK is Null AND t1.PhysicalDiskModelIDFK is Null)) AND (t2.TierID = t1.TierID or (t2.TierID is Null AND t1.TierID is Null)) AND (t2.Ordinal = t1.Ordinal or (t2.Ordinal is Null AND t1.Ordinal is Null)) AND (t2.EnvironmentID = t1.EnvironmentID or (t2.EnvironmentID is Null AND t1.EnvironmentID is Null)) AND (t2.ShareMode = t1.ShareMode or (t2.ShareMode is Null AND t1.ShareMode is Null)) AND (t2.SubjectComponent = t1.SubjectComponent or (t2.SubjectComponent is Null AND t1.SubjectComponent is Null)) AND (t2.FormatCommand = t1.FormatCommand or (t2.FormatCommand is Null AND t1.FormatCommand is Null)) AND (t2.Description = t1.Description or (t2.Description is Null AND t1.Description is Null)) AND (t2.Function = t1.Function or (t2.Function is Null AND t1.Function is Null)) AND (t2.Caching = t1.Caching or (t2.Caching is Null AND t1.Caching is Null)) AND (t2.writeAcceleratorEnabled = t1.writeAcceleratorEnabled or (t2.writeAcceleratorEnabled is Null AND t1.writeAcceleratorEnabled is Null)) AND (t2.Caching = t1.Caching or (t2.Caching is Null AND t1.Caching is Null))
WHERE (((t1.Ordinal) Is Null) AND ((t1.EnvironmentID) Is Null) AND ((t1.TierID) Is Null) AND ((t1.PhysicalDiskModelIDFK) Is Null) AND ((t1.VolumeNameIDFK) Is Null) AND ((t1.DiskNumber) Is Null) AND ((t1.FileSystemType) Is Null) AND ((t1.PercentSnapshotSpace) Is Null) AND ((t1.ShareMode) Is Null) AND ((t1.SubjectComponent) Is Null) AND ((t1.FormatCommand) Is Null) AND ((t1.Description) Is Null) AND ((t1.Function) Is Null) AND ((t1.Caching) Is Null) AND ((t1.writeAcceleratorEnabled) Is Null));

SELECT DISTINCT * 
FROM   tblvolumes AS t2 
       LEFT JOIN qryim_sourcevolumes AS t1 
              ON ( t2.percentsnapshotspace = t1.percentsnapshotspace 
                    OR ( t2.percentsnapshotspace IS NULL 
                         AND t1.percentsnapshotspace IS NULL ) ) 
                 AND ( t2.filesystemtype = t1.filesystemtype 
                        OR ( t2.filesystemtype IS NULL 
                             AND t1.filesystemtype IS NULL ) ) 
                 AND ( t2.disknumber = t1.disknumber 
                        OR ( t2.disknumber IS NULL 
                             AND t1.disknumber IS NULL ) ) 
                 AND ( t2.volumenameidfk = t1.volumenameidfk 
                        OR ( t2.volumenameidfk IS NULL 
                             AND t1.volumenameidfk IS NULL ) ) 
                 AND ( t2.physicaldiskmodelidfk = t1.physicaldiskmodelidfk 
                        OR ( t2.physicaldiskmodelidfk IS NULL 
                             AND t1.physicaldiskmodelidfk IS NULL ) ) 
                 AND ( t2.tierid = t1.tierid 
                        OR ( t2.tierid IS NULL 
                             AND t1.tierid IS NULL ) ) 
                 AND ( t2.ordinal = t1.ordinal 
                        OR ( t2.ordinal IS NULL 
                             AND t1.ordinal IS NULL ) ) 
                 AND ( t2.environmentid = t1.environmentid 
                        OR ( t2.environmentid IS NULL 
                             AND t1.environmentid IS NULL ) ) 
                 AND ( t2.sharemode = t1.sharemode 
                        OR ( t2.sharemode IS NULL 
                             AND t1.sharemode IS NULL ) ) 
                 AND ( t2.subjectcomponent = t1.subjectcomponent 
                        OR ( t2.subjectcomponent IS NULL 
                             AND t1.subjectcomponent IS NULL ) ) 
                 AND ( t2.formatcommand = t1.formatcommand 
                        OR ( t2.formatcommand IS NULL 
                             AND t1.formatcommand IS NULL ) ) 
                 AND ( t2.description = t1.description 
                        OR ( t2.description IS NULL 
                             AND t1.description IS NULL ) ) 
                 AND ( t2.function = t1.function 
                        OR ( t2.function IS NULL 
                             AND t1.function IS NULL ) ) 
                 AND ( t2.caching = t1.caching 
                        OR ( t2.caching IS NULL 
                             AND t1.caching IS NULL ) ) 
                 AND ( t2.writeacceleratorenabled = t1.writeacceleratorenabled 
                        OR ( t2.writeacceleratorenabled IS NULL 
                             AND t1.writeacceleratorenabled IS NULL ) ) 
                 AND ( t2.caching = t1.caching 
                        OR ( t2.caching IS NULL 
                             AND t1.caching IS NULL ) ) 
WHERE  ( ( ( t1.ordinal ) IS NULL ) 
         AND ( ( t1.environmentid ) IS NULL ) 
         AND ( ( t1.tierid ) IS NULL ) 
         AND ( ( t1.physicaldiskmodelidfk ) IS NULL ) 
         AND ( ( t1.volumenameidfk ) IS NULL ) 
         AND ( ( t1.disknumber ) IS NULL ) 
         AND ( ( t1.filesystemtype ) IS NULL ) 
         AND ( ( t1.percentsnapshotspace ) IS NULL ) 
         AND ( ( t1.sharemode ) IS NULL ) 
         AND ( ( t1.subjectcomponent ) IS NULL ) 
         AND ( ( t1.formatcommand ) IS NULL ) 
         AND ( ( t1.description ) IS NULL ) 
         AND ( ( t1.function ) IS NULL ) 
         AND ( ( t1.caching ) IS NULL ) 
         AND ( ( t1.writeacceleratorenabled ) IS NULL ) );

( t2.percentsnapshotspace = t1.percentsnapshotspace 
                    OR ( t2.percentsnapshotspace IS NULL 
                         AND t1.percentsnapshotspace IS NULL ) )

 Nz(t2.percentsnapshotspace,"NULL") = Nz(t1.percentsnapshotspace,"NULL")