Re: Help with SQL syntax

Posted in 1995

Gary Rooksby — Mon, 18 Dec 1995 15:26:51 -0800 — source: Informix-list mailing list archive (1991-1998)

Try a nested select statement such as: SELECT account.acc_name, account.password FROM account WHERE account.acc_name NOT IN (SELECT UNIQUE acc_name FROM temp) :-) -- Gary Rooksby aa46@dial.pipex.com