Hello!
Sorry for the incomplete information...
The complete select is:
SELECT
lt.cikk_ID, SUM(bt.mennyiseg)
FROM traktar_leltartetelek_new lt
LEFT JOIN traktar_mozgas_bizonylat_cikk bt ON bt.cikk_ID=lt.cikk_ID and
bt.raktar_ID="01"
WHERE lt.leltar_ID="000"
GROUP BY lt.cikk_ID
And table structure:
traktar_leltartetelek_new
-------------------------------------
Field Type Null Key Default Extra
ID char(18) PRI
leltar_ID char(18)
cikk_ID char(18) MUL
szamolt_keszlet double YES NULL
traktar_mozgas_bizonylat_cikk
-------------------------------------
Field Type Null Key Default Extra
ID varchar(18) PRI
biz_ID varchar(18) MUL
cikk_ID varchar(18)
raktar_ID varchar(18)
mennyiseg double YES NULL
Name Type Row_format Rows
traktar_leltartetelek_new MyISAM Fixed 2334
traktar_mozgas_bizonylat_cikk MyISAM Dynamic 78483
Best Regards!
Zoltán
----- Original Message -----
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To: "Gyurasits Zoltán" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
Sent: Monday, June 13, 2005 10:01 AM
Subject: Re: Optimises LEFT JOIN
From: "Gyurasits Zoltán"
I have a speed problem with LEFT JOIN condition.
(...)
Why?? Somebody can help me? Tnx!!
You will probably get a lot more useful response if you include the table
structure, the complete query/queries and the output of EXPLAIN for each
query (just put EXPLAIN in front of the SELECT. It will give you
information
about the execution path that MySQL came up with).
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
