Re: [SQL] sub-selects

2005-05-16 Thread PFC
SELECT foo.*, npoints( foo.g ) FROM (SELECT a, (select b from c where d = e limit 1) AS g FROM f WHERE isValid( g )) AS foo ? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail comma

[SQL] sub-selects

2005-05-16 Thread Mark Fenbers
Is there a way to make a query more efficient by executing a sub-select only once? In a query such as: SELECT a, (select b from c where d = e limit 1), npoints( (select b from c where d = e limit 1) )     FROM f     WHERE isValid( (select b from c where d = e limit 1) ); I do the same sub-se