[linux] OT: pomoc s sql prikazom ...

Juraj Bednar juraj na bednar.sk
Středa Srpen 15 18:50:18 CEST 2001


On Wed, Aug 15, 2001 at 06:47:44PM +0200, Oskar Stolc wrote:
> On Wed, Aug 15, 2001 at 06:39:20PM +0200, Michal Vadila wrote:
> > On Wed, 15 Aug 2001, Oskar Stolc wrote:
> > 
> > > 		from tabulka
> > > 		where jedlo = 'chlieb'
> > >
> > > b) maslo a paradajku (t.j. by mal vratit maja 'jano' a 'duro'
> > >
> > > 		hmmm, ako by mal vyzerat tento selekt?
> > >
> > select * from tabulka where jedlo = 'maslo' or jedlo = 'chlieb';
> > 
> > 
> > :-)
> > 
> 
> To nie je dobre, lebo mi vrati aj takych ludi, co jedli len
> 'maslo' bez 'chlaba' alebo 'chlieb' bez 'masla'. A ja chcem len
> takych, ktory jedli sucasne 'chlieb' aj s 'maslom'

select j.meno from tabulka j, tabulka p where p.jedlo='maslo' and
j.jedlo='chlieb';

Potrebujes spravit join z dvoch tabuliek.


    Juraj.


-- 
-----------------------------------------------------------------------
|Juraj Bednar             | Homepage at http://juraj.bednar.sk/       |
|computer journalist      | Store at http://www.geekstore.sk/         |
|system administrator     | PGP key: http://juraj.bednar.sk/          |
|independent consultant   | Please stand for your freedom!            |
|Please don't send me mail using proprietary file formats             |
-----------------------------------------------------------------------




Další informace o konferenci linux