Re: help with multi-table query

Posted in 1993

informix users bb — Tue, 2 Mar 93 15:50:28 MST — source: Informix-list mailing list archive (1991-1998)

rickey, the following should do the trick: select lastname from table1 where lastname not in (select lastname from table2 where firstname != 'doug') ------------------------------------------------------------------------------ | . . Bob Baskett | ... ... Software Engineer, DBA | ..... ..... Business Systems Integration Group | .. ... .. Semiconductor Products Sector | . . . Mesa, AZ | | Motorola, Inc ------------------------------------------------------------------------------ Sun 690-MP Informix Versions: Online - 5.00.UC2 ISQL - 4.10.UD1 4GL-RDS- 4.10.UC1 ------------------------------------------------------------------------------