Apr 19
Steve Piercy - Website Builder improve nested query
Apr 19, 2015; 13:04
Steve Piercy - Website Builder
improve nested query
Given this query.
select
t1.id,
t1.name
from
t1
where
name like '%moose%'
limit 50
While looping through the found record set, I perform a nested
query (SQL/Lasso syntax is simplified):
select
count(t2.distributor_id) as count
from
t2
where
t2.stout_id = #row->find('id')
OR t2.porter_id = #row->find('id')
This will perform N nested queries, where N equals the LIMIT
value of the outer query, finding the count of distributors that
carry a stout or porter that matches the outer query's row id.
It works, but performing that many nested queries seems
inefficient to me.
Is there a better query where the column 'count' from the inner
query could be rolled up into the outer query? I've tried
dozens of permutations with subquery and join, but without success.
Thank you!
--steve
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy Website Builder Soquel, CA
<web@StevePiercy.com> <http://www.StevePiercy.com/>
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Apr 19
Bil Corry Re: improve nested query
Apr 19, 2015; 22:23
Bil Corry
Re: improve nested query
Apr 19
Brad Lindsay Re: improve nested query
Apr 19, 2015; 17:10
Brad Lindsay
Re: improve nested query
Apr 19
Steve Piercy - Website Builder Re: improve nested query
Apr 19, 2015; 18:41
Steve Piercy - Website Builder
Re: improve nested query
Apr 19
Steve Piercy - Website Builder Re: improve nested query
Apr 19, 2015; 18:41
Steve Piercy - Website Builder
Re: improve nested query
Apr 20
Wade Maxfield Re: improve nested query
Apr 20, 2015; 14:26
Wade Maxfield
Re: improve nested query
Apr 20
Tom Brown, Liberty Wines RE: improve nested query
Apr 20, 2015; 02:31
Tom Brown, Liberty Wines
RE: improve nested query
Apr 20
Tom Brown, Liberty Wines RE: improve nested query
Apr 20, 2015; 02:34
Tom Brown, Liberty Wines
RE: improve nested query
Apr 20
Marc Vos Re: improve nested query
Apr 20, 2015; 06:07
Marc Vos
Re: improve nested query
Apr 20
Ke Carlton Re: improve nested query
Apr 20, 2015; 16:09
Ke Carlton
Re: improve nested query
Apr 19
Steve Piercy - Website Builder Re: improve nested query
Apr 19, 2015; 21:47
Steve Piercy - Website Builder
Re: improve nested query
Apr 19
Steve Piercy - Website Builder Re: improve nested query
Apr 19, 2015; 21:56
Steve Piercy - Website Builder
Re: improve nested query