in reply to Re: Re: (OT) Improving a SQL JOIN statement
in thread (OT) Improving a SQL JOIN statement

I've omitted the SQL portions that grab several other fields from the item table at the same time as sorting on the second table, as to prepare all this for perl and HTML output. I know that if I just wanted the average, I don't even need to JOIN.
Dr. Michael K. Neylon - mneylon-pm@masemware.com || "You've left the lens cap of your mind on again, Pinky" - The Brain
  • Comment on Re: Re: Re: (OT) Improving a SQL JOIN statement

In Section Seekers of Perl Wisdom