Hans, Select * from table where Not Object ie. the user entry box "that satisfy" should contain the words "not object" I'm not sure if this is in the manual but it should be!! Regards, Brendan Henry Senior GIS Officer Queensland Department of Main Roads "hans coesel" <[EMAIL PROTECTED]> on 11/01/2001 12:27:25 Please respond to "hans coesel" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: Brendan A Henry/SouthEast/QMR/Au) Subject: MI-L Hello, This is probably a simple question, but I have not had succes in figuring it out so far. I have several tables which have been geocoded. The problem is that some of the entries did not geocode. What I want is to extract, into a temporary table those entries which have no geocode. I have tried to set up a temporary table of only those who have geocodes, but I see no way of us that table to retrieve the remiander of the original table. I would have thought that using NOT inthe query would do it, but it is not working. Any questions? hans [EMAIL PROTECTED] ************************************************************ Opinions contained in this e-mail do not necessarily reflect the opinions of the Queensland Department of Main Roads, Queensland Transport or National Transport Secretariat, or endorsed organisations utilising the same infrastructure. If you have received this electronic mail message in error, please immediately notify the sender and delete the message from your computer. ************************************************************
|
Hello,
This is probably a simple question, but I have not had succes
in figuring it out so far.
I have several tables which have been geocoded. The
problem is that some of the entries did not geocode.
What I want is to extract, into a temporary table those
entries which have no geocode. I have tried to set up a temporary table of
only those who have geocodes, but I see no way of us that table to retrieve
the remiander of the original table.
I would have thought that using NOT inthe query would do it,
but it is not working.
Any questions?
hans
|
