RE: SQL

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