--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
03.06.2009 10:01:54 qSab: Cannot perform this operation on a closed dataset : SELECT 

if(ISNULL(tkategorie.KategorieTxt), tchody.ChodTxt, CONCAT(tchody.ChodTxt,'      "',tkategorie.KategorieTxt,'"')) AS txt,
tchody.ChodTxt,
tkategorie.KategorieTxt,
rtr_sablony.*,
tchody.Chod_Id

FROM rtr_sablony
LEFT JOIN tchody ON Variant = Chod_Id
LEFT JOIN tkategorie ON id_kategorie = Kategorie_Id

WHERE id_misto = (1+0)  AND sgrp = 1
ORDER BY poradi_jid, Priority DESC


