> > select a.ip, b.foo from tablea a, tableb b where a.id=b.id and > not (a.ip <<= any (select network from assets where network is not null)) > > regards, tom lane
Yes, that did it. I guess I'll have to hit the books again to fully grok what you did. THANKS! --- Let us all bask in television's warm glowing warming glow --- Scott Brunza 860.326.3637 scot...@sonalysts.com This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender.
smime.p7s
Description: S/MIME cryptographic signature