Posted By: Ray (Keep on the sunny side) on 'CZdatabases' Title: Pes Date: Tue Aug 8 06:21:13 2000 Ahojte, tak ze si po ranu kouknu na Psa a co nevidim Chyba v SQL: SELECT distinct clanek.cid,nazev,dat_publ,pozice FROM clanek, clrubrel WHERE (clrubrel.rid = 0) AND (clrubrel.prid = 0) AND (clrubrel.pprid = 0) AND (clrubrel.cid = clanek.cid) AND (clanek.web = 4) AND (clanek.stav >= 40) AND (clanek.stav != 99) AND (clanek.dat_publ < '2000-08-09 00:00:00') AND typ=1 ORDER BY dat_publ DESC, pozice ASC Skoda, ze neprilozili schema, takhle neni moc jasny, kde ta chyba je :))) Ray