Help with SQL syntax
Posted in 1995
Dean hobbs — — source: Informix-list mailing list archive (1991-1998)
Hi,
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 WHEREaccount.acc_name = temp.acc_name AND temp.acc_name IS NOT NULL
Can anybody tell me where I am going wrong. In the manual it says that
there should be a null entry in the 2nd table which is what I would expect
but I still can't get it to work.
Thanks in advance.
Dean Hobbs
deanh@unipalm.pipex.com