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 

Search the boards