how do I create a non equal join?

[Guest]

I am updating tables from a server through a data extract process. I would
like to delete records to the primary table (that don't match the primary key
'empnum') and append records to the primary table (that don't match the
primary key 'empnum').
For example: the table general information (in one database) has added 13
new customers and deleted 4 old customers. I would like to add and delete
the customer records to the general infomation (replica) table using a non
equal join to only delete and append where the employee number is not equal.

 

[Guest]

I usually just use a Right or Left join as appropriate, and then specify that
one of the field ID's is Null.

For instance, for the append query, you would want tGeneralCurrent LEFT JOIN
tGeneralReplica, and you would want the condition that tGeneralReplica.empnum
Is Null.

The delete query would be pretty much the opposite.

HTH, post back if you have further questions or if I misunderstood the
question.

-Ted Allen

 

[Guest]

Thanks! I tried your answer on the select query and it worked. However for
the delete query, I keep getting an error message that says, "specify the
table containing the records you want to delete" but for some reason in the
delete section, I can't select "from" and it keeps defaulting to "where" The
append query works fine because it lets me choose the table to append to in
the beggining. For some reason my delete query won't work.

HELP!

 

[Guest]

Try selecting the * from the table that you want to delete the records from.
Then Access should let you specify from (actually it will probably default to
it).

HTH, Ted Allen

 

[Guest]

THANK YOU! THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK
YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK
YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!

 

[Guest]

My pleasure, glad it helped.

THANK YOU! THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK
YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK
YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!THANK YOU!