Hi Eric,
I'll second Bob Hall's opinion.
One could extend a query so that it checks also your additional condition.
You haven't gotten to the 'group by' and 'having' goodies, that's the hint.
But this would make it over-complicated,
and MySQL could run into problems when attempting to evaluate t
Sir, here's a guess in return. The best way to deal with this is to
have your client app run a query that counts the rows where
packagesParts.pri <> 0. Then run the query below only if the count is
greater than 0.
Bob Hall
>Hi,
>
>I am guessing this is the kind of problem that would be easier