Article View: pl.comp.lang.delphi.bazy-danych
Article #70384Re: zapytanie typu select where in select
From: Morff
Date: Tue, 10 Jul 2007 17:21
Date: Tue, 10 Jul 2007 17:21
19 lines
1198 bytes
1198 bytes
Dnia 10-07-2007 o 14:34:47 jacky <jfrieskeNoSPam@poczta.onet.pl> napisaล: > Witam. > > Baza Firebird 2.0.1 [..] > Czy powyzsze zapytanie mozna skonstruowac bardziej optymalnie? > > Pozdrawiam select numernad from doknad where not exists (select 1 from dokpod where doknad.numernad=dokpod.numerpod) -- Pozdrawiam Morff -------------------- AQQ 141151
Technical Details
Message-ID:
<op.tu9ehvanq0kutt@xp_januszk.wag54gs>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mailReferences:
<f6vu30$ude$1@news.onet.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail From: Morff <morff1@wp.pl> Newsgroups: pl.comp.lang.delphi.bazy-danych Subject: Re: zapytanie typu select where in select Date: Tue, 10 Jul 2007 19:21:21 +0200 Organization: tp.internet - http://www.tpi.pl/ Lines: 19 Message-ID: <op.tu9ehvanq0kutt@xp_januszk.wag54gs> References: <f6vu30$ude$1@news.onet.pl> NNTP-Posting-Host: can101.neoplus.adsl.tpnet.pl Mime-Version: 1.0 X-Trace: atlantis.news.tpi.pl 1184088176 13893 83.30.85.101 (10 Jul 2007 17:22:56 GMT) X-Complaints-To: usenet@tpi.pl NNTP-Posting-Date: Tue, 10 Jul 2007 17:22:56 +0000 (UTC) User-Agent: Opera Mail/9.22 (Win32) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit