MySQL- if exists

[Honza Pazdziora]

On Mon, Apr 09, 2001 at 07:09:58PM +0200, J.Paryzek wrote:
> 
> Existuji moznosti zapisu v MySQL obdobne jako pro ORACLE  :
> 
> where not exists (select * from <nazev tabulky> t2
>                   where t1.znak>t2.znak);

Na not exists pouzijte outer join a test na null.

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, DBD::XBase.
------------------------------------------------------------------------