AV1611 Posted March 30, 2006 Share Posted March 30, 2006 Select avg(distinct (firstpass4.pass/(firstpass3.pass+firstpass4.pass))*100) as avg90 from firstpass3,firstpass4 where firstpass3.it_date=firstpass4.it_date order by firstpass3.it_date DESC limit 90 Quote Link to comment https://forums.phpfreaks.com/topic/6186-solved-how-do-you-do-this/ Share on other sites More sharing options...
ober Posted March 30, 2006 Share Posted March 30, 2006 Did you run it? Did it provide any errors? Give us a little more information!!!!!!! We're not mind readers! Quote Link to comment https://forums.phpfreaks.com/topic/6186-solved-how-do-you-do-this/#findComment-22334 Share on other sites More sharing options...
AV1611 Posted March 30, 2006 Author Share Posted March 30, 2006 I'm sorry, mysql error... I think you can't avg on as distinct... but I'm not sure... it doesn't work in my query browser either...// problem solved... if anyone wants to know... I'll post if you want it... but I doubt anyone cares... Quote Link to comment https://forums.phpfreaks.com/topic/6186-solved-how-do-you-do-this/#findComment-22347 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.