Re: Help with SQL syntax

On 15 Dec 1995, Dean hobbs wrote: >>> stuff deleted <<< > I am trying to find records in one table that do not have matchin entries > in another table. I have done this before in Access but cannot get it to > work with Informix. Here is the syntax I am using. > > SELECT account.acc_name, account.password FROM account, OUTER temp WHERE> account.acc_name = temp.acc_name AND temp.acc_name IS NOT NULL > > deanh@unipalm.pipex.com Dean, Have you created the temp table? Read me the error messages? If acc_name is a key, you should always get an answer, i.e. acc_name should never be null. Just try the join without the not null. Yours, Nick ********************************* Nick Nobbe, Library of Congress NLS/BPH mail: nnob@loc.gov *********************************