Jump to content

Archived

This topic is now archived and is closed to further replies.

AV1611

**SOLVED** How do you do this?

Recommended Posts

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

Share this post


Link to post
Share on other sites
Did you run it? Did it provide any errors? Give us a little more information!!!!!!! We're not mind readers!

Share this post


Link to post
Share on other sites
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...

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.