Hi I'm to stupid to write sql but im trying my hand at it anyways.
I cant work this out any easier than doing a seperate command but when i do that it takes forever. So i tried doing it as a subquery, but i think somehow i need to make it loop through my result set and do something special, but im not sure how to do it.
After i run this:

select aditm, adfvtr/10000 as price, ADAST,  (select max(adfvtr)/10000
from f4072
where adast = '510LIS' and 108284 < adexdj and 108284 > adeftj and admnq = 1  and aditm = '15'
group by aditm) as listprice
from f4072
where adast like '510%' and aditm  = '15'

I get this:

15 172.9 510LIS 198.835
15 198.835 510LIS 198.835
15 172.9 510RES 198.835
15 198.835 510RES 198.835

Which is correct, but what i want is that same code to apply to all of the records in ADITM

For example if aditm = 16 then i would want the rest of that subquery to be based around aditm = 16

If this makes no sense, please disregard and forget you ever read it

10 Years
Discussion Span
Last Post by dickersonka

not sure what you are calling the code from, but you could either use a stored procedure with aditm passed in or create a view and filter the results based upon aditm

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.