Posted By: snake (Keeping on the sunny side) on 'CZdatabases' Title: Re: select z 2 radku do 2 sloupcu? Date: Thu Apr 3 21:41:21 2003 > > select > > A1.zaznam as zaz1, A2.zaznam as zaz2 > > from > > table A1, table A2 > > where > > A1.zaznam='PODMINKA' and A2.zaznam='Podminka, kerou nesplnuje prvni > > zaznam' > > to by slo, > jenze co kdyz mam pouze 1 tabulku? SELECT tabulka.sloupec,tabulka_2.sloupec FROM tabulka, tabulka as tabulka_2 WHERE tabulka.sloupec < tabulka_2.sloupec Mne tohle funguje u Accessu i nad textovejma retezcema, netusim, jak to bude u Tve databaze, pripadne by sis musel upravit ten operator "<" v podmince WHERE. snake