On 1/18/2015 5:58 PM, James Sewell wrote:
WITH idlist as (SELECT id from othertable)
SELECT id from mastertable WHERE id = idlist.id);
select mt.id, ... from mastertable mt join othertable ot on mt.id=ot.id;
might optimize better.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
