L
Leif
I'm tried to create an unmatched query to determine what
records need to be added to a table. On one side I have a
query that runs against a linked table (records to bring
in). On the other side I have a local table.
The problem I'm having is that fields that have a null
value on both sides I want to consider a match. However,
in SQL, a comparision involving a null value always
returns a null.
I tried adding an nz function on both sides of the equi-
join. However, that makes the query VERY LONG. Without
the nz the query takes 1 minute and 20 seconds. With the
nz I killed the query after it ran more than 1 hour. Of
course, nz also does not allow me to use design mode for
the query anymore.
Any suggestions?
records need to be added to a table. On one side I have a
query that runs against a linked table (records to bring
in). On the other side I have a local table.
The problem I'm having is that fields that have a null
value on both sides I want to consider a match. However,
in SQL, a comparision involving a null value always
returns a null.
I tried adding an nz function on both sides of the equi-
join. However, that makes the query VERY LONG. Without
the nz the query takes 1 minute and 20 seconds. With the
nz I killed the query after it ran more than 1 hour. Of
course, nz also does not allow me to use design mode for
the query anymore.
Any suggestions?