Re: query that needs two nested queries, is this the best

Richard Huxton wrote:
> SELECT id FROM p4_versions WHERE
>   (versionof, version) IN (SELECT id,headver FROM p4_files WHERE ...)

Ahh, just what I was looking for...

Thanks All!
Mark