Hello,
could you tell me where is different or where is an mistake?
and
there is 23 seconds different. The first order only make temporary table.
could you tell me where is different or where is an mistake?
Code:
CREATE TEMPORARY TABLE Pomocna_tabulka
SELECT Edar_Nakupy.Sleva AS Sleva, Edar_Nakupy.Duvod_slevy AS Duvod_slevy, ( Edar_Zbozi.Nakupni_cena * ( 1 - ( Edar_Nakupy.Sleva /100 ) ) ) AS Nakupni_cena_po_sleve, ( Edar_Zbozi.Nakupni_cena * Edar_Zbozi.Nakupni_kurz ) AS Nakupni_cena_v_mene, ( Edar_Zbozi.Nakupni_cena * ( 1 - ( Edar_Nakupy.Sleva /100 ) ) * Edar_Zbozi.Nakupni_kurz ) AS Nakupni_cena_v_mene_po_sleve, Edar_Zbozi.Prodejni_cena AS Konecna_cena, ( Edar_Zbozi.Prodejni_cena * ( 1 + ( Edar_Prodeje.Dph /100 ) ) ) AS Konecna_cena_s_dph, ( ( ( Edar_Zbozi.Prodejni_cena *100 ) / ( Edar_Zbozi.Nakupni_cena * Edar_Zbozi.Nakupni_kurz ) ) -100 ) AS Rabat, Edar_Zbozi. * , Edar_Skupiny.Nazev AS Nazev_skupiny, Edar_Podskupiny.Nazev AS Nazev_podskupiny, Edar_Polozky.Obrazek AS Obrazek
FROM Edar_Prevody, Edar_Nakupy, Edar_Prodeje, Edar_Zbozi, Edar_Skupiny, Edar_Podskupiny, Edar_Polozky
WHERE 7
LIKE Edar_Zbozi.Id_prevodu AND Edar_Zbozi.Id_prevodu
LIKE Edar_Prevody.Id AND Edar_Zbozi.Id_prodeje
LIKE Edar_Prodeje.Id AND Edar_Zbozi.Id_nakupu
LIKE Edar_Nakupy.Id AND Edar_Prevody.Datum
BETWEEN 0 AND 1103817635 AND Edar_Podskupiny.Id_skupiny
LIKE Edar_Skupiny.Id AND Edar_Polozky.Id_podskupiny
LIKE Edar_Podskupiny.Id AND Edar_Zbozi.Id_polozky
LIKE Edar_Polozky.Id
ORDER BY Nazev_polozky ASC
and
Code:
SELECT Edar_Nakupy.Sleva AS Sleva, Edar_Nakupy.Duvod_slevy AS Duvod_slevy, ( Edar_Zbozi.Nakupni_cena * ( 1 - ( Edar_Nakupy.Sleva /100 ) ) ) AS Nakupni_cena_po_sleve, ( Edar_Zbozi.Nakupni_cena * Edar_Zbozi.Nakupni_kurz ) AS Nakupni_cena_v_mene, ( Edar_Zbozi.Nakupni_cena * ( 1 - ( Edar_Nakupy.Sleva /100 ) ) * Edar_Zbozi.Nakupni_kurz ) AS Nakupni_cena_v_mene_po_sleve, Edar_Zbozi.Prodejni_cena AS Konecna_cena, ( Edar_Zbozi.Prodejni_cena * ( 1 + ( Edar_Prodeje.Dph /100 ) ) ) AS Konecna_cena_s_dph, ( ( ( Edar_Zbozi.Prodejni_cena *100 ) / ( Edar_Zbozi.Nakupni_cena * Edar_Zbozi.Nakupni_kurz ) ) -100 ) AS Rabat, Edar_Zbozi. * , Edar_Skupiny.Nazev AS Nazev_skupiny, Edar_Podskupiny.Nazev AS Nazev_podskupiny, Edar_Polozky.Obrazek AS Obrazek
FROM Edar_Prevody, Edar_Nakupy, Edar_Prodeje, Edar_Zbozi, Edar_Skupiny, Edar_Podskupiny, Edar_Polozky
WHERE 7
LIKE Edar_Zbozi.Id_prevodu AND Edar_Zbozi.Id_prevodu
LIKE Edar_Prevody.Id AND Edar_Zbozi.Id_prodeje
LIKE Edar_Prodeje.Id AND Edar_Zbozi.Id_nakupu
LIKE Edar_Nakupy.Id AND Edar_Prevody.Datum
BETWEEN 0 AND 1103817635 AND Edar_Podskupiny.Id_skupiny
LIKE Edar_Skupiny.Id AND Edar_Polozky.Id_podskupiny
LIKE Edar_Podskupiny.Id AND Edar_Zbozi.Id_polozky
LIKE Edar_Polozky.Id
ORDER BY Nazev_polozky ASC
there is 23 seconds different. The first order only make temporary table.