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 <http://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
