Re: Joining On Procedure Results

[Peter Brawley]

> Is it possible to join a table on the results from a stored procedure within a single query?

No.

And in the query ...

select id, values 
from mytable
where maxTarget = (
  select max(maxTarget) 
  from mytable where id = _id 
  group by id
);

Group By is useless in the subquery, and it would be more efficient to move the subquery to the FROM clause, eg ...

select id, values 
from mytable m
join (
  select max(maxTarget) as maxt 
  from mytable where id = _id 
) t on m.maxtarget = t.maxt;

PB
http://www.artfulsoftware.com