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 ---
This e-mail and any files transmitted with it may be proprietaryand 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.
|
<<attachment: smime.p7s>>