On 6/29/07, Ken <[EMAIL PROTECTED]> wrote:
You can also do: select count(*) from guid_version_map where guid||version not in (select guid||version from latest_version) Its not exactly the same, typically only good for small results. Thanks... my results will have millions of rows, :) but good to know the
things that I've forgotten in a decade of working around select(tuples)in... I would probably choose to use where guid||','||version not in (select guid||','||version) just to avoid issues of guid=101,version=10 not match guid=10,version=110. :) --a