That looks better! Thanks for your help
Cheers,
Randy
On Wed, 8 Nov 2000, Nick Fankhauser wrote:
>
> how about:
>
> SELECT banid FROM a WHERE flags NOT LIKE '%v%' AND banid NOT IN (SELECT
> banid FROM b);
>
> -Nick
>
> ----------------------------------------------------------------------------
> -----
> Nick Fankhauser
>
> Business: nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
> Ray Ontko & Co. Software Consulting Services
> http://www.ontko.com/
>
> Personal: nickf@infocom.com http://www.infocom.com/~nickf
>
>
>
Randy Jonasz
Software Engineer
Click2net Inc.
Web: http://www.click2net.com
Phone: (905) 271-3550
"You cannot possibly pay a philosopher what he's worth,
but try your best" -- Aristotle