Hello all
I have a problem to report. There is a SELECT query that selects data from
three tables according to certain criteria. It goes like this:
SELECT bglavna.T001, bpolja.ID AS ID2, bpotpolja.TEKST
FROM (bglavna INNER JOIN bpolja ON bglavna.ID=bpolja.FK) INNER JOIN
bpotpolja ON bpolja.ID=bpotpolja.FK
WHERE bpolja.TAG = '200' AND bpotpolja.SUBF = 'a' AND bglavna.ID IN (...);
"..." is replaced by a subquery that works perfectly and goes like this:
SELECT bglavna.ID FROM (bglavna INNER JOIN bpolja ON bglavna.ID = bpolja.FK)
INNER JOIN bpotpolja ON bpolja.ID = bpotpolja.FK WHERE bpolja.TAG = '700'
AND bpotpolja.SUBF = 'a' AND bpotpolja.TEKST = 'kishon'
As it can be seen, two very similar queries executed on same tables.
Subquery works perfectly and gives the results immediately. But when i put
it in the first query, disk activity does not stop at all and I need to kill
the process. Then I execute subquery, gather results and separate them with
comma(", ") and put them in the first query and everything works perfectly.
So, first query works good when results are explicitly given, and second
query works fine all the time, but when I join them together, everything
stops functioning. I indexed almost every column but it did not help. These
kind of queries allways worked, I don't know what could have happened. Every
sugestion is highly appreciated.
Thank you
Bruno
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
