[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