Linked Field And Null Values

All,

Introduction (I case I'm doing this all wrong)

I have 1 huge table of data:

SysID
PersonData
"
"
"
"
AddressData
"
"
"
"
"
"
"
"
"
TelephoneData
"
"
"
"
Year (this is 1 or 2)

I'm taking each component Person, Address, Telephone info and making a compacted table of each (i.e. lots of Jane Does etc, appear in both years)
Each table with have a URN

I then need to update the big table with the URN so move onto another part of getting this data into a usable format.

Basically what follows is my question on how to get the URN's back into the table:

-----------------------------------------------------------------------

Is there a quicker way (or a way I'm not seeing) of doing the following.

I have a set of data 'tblDatabaseTable, say:

ID
Field1
Field2
Field3
Field4

In the database.

I have an imported file which will be tblImportTable, same deal without the ID:

Field1
Field2
Field3
Field4

I need to compare the data on each table:

SELECT * FROM tblDatabaseTable
INNER JOIN tblDatabaseTable
ON tblDatabaseTable.Field1 = tblImportTable.Field1
AND tblDatabaseTable.Field2 = tblImportTable.Field2
AND tblDatabaseTable.Field3 = tblImportTable.Field3;

Works great as long as all the fields have values in.

Is there a way to compare the tables and get results as:

Database
Ian MacConnell null

Import
Ian Macconnell null

Match!

without doing something like:

SELECT IIf(IsNull([Field1]),' ',[Field1]),
IIf(IsNull([Field2]),' ',[Field2]),
IIf(IsNull([Field3]),' ',[Field3])
FROM DatabaseTable

SELECT IIf(IsNull([Field1]),' ',[Field1]),
IIf(IsNull([Field2]),' ',[Field2]),
IIf(IsNull([Field3]),' ',[Field3])
FROM ImportTable

before comparing them???

Phew, hope that all makes sense, very long day and I'm........

Cheers,