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