|
Posted by Bob Bedford on 10/19/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 ?
Navigation:
[Reply to this message]
|