Posted by Bob Bedford on 10/10/26 11:27

Forget about the looooong query. I've simplified it in order to eliminate
all possible error source.

Here is the simplest query that fails sometimes:

SELECT *
FROM type
INNER JOIN mod ON type.modcode = mod.modcode
INNER JOIN mak ON mod.makecode = mak.makecode

this query works
SELECT *
FROM type
INNER JOIN mod ON type.modcode = mod.modcode

So it seems that as soon as you put 2 inner joins with a table named "type"
then it fails: sometimes I get records, sometimes not.
with query results, the result count is 0-0 (1 total) (in phpmyadmin)

any idea ?

[Back to original message]