> Hm, tak nevim co delam spatne, ten dotaz je > --- > SELECT * FROM objednavky WHERE YEAR(DATUM) = 2003 ORDER BY '(SELECT > prijmeni FROM klienti ORDER BY prijmeni)', prijmeni > --- > ty uvozovky tam musí byt, jinak mi to PHPko nevezme, ale stejne mi to > seradi jen polozky v tabulce OBJEDNAVKY, ale ty z KLIENTI mi to stale > neradi, hodi je to na zacatek. V jake db to delas? V MySQL by mely byt subquery podporovany az ve verzi 5. Ale jestli tomu dobre rozumim, tak chces neco takovyho: SELECT * FROM klienti RIGHT JOIN objednavky ON klienti.id = objednavky.id_klienta WHERE YEAR(DATUM) = 2003 ORDER BY IIf(IsNull([objednavky].[prijmeni]),[klienti].[prijmeni],[objednavky].[prijmeni]); -- cao, Kamil
This archive was generated by hypermail 2.1.3 : 01. 09. 2003, 11:06 CEST