Article View: pl.comp.lang.delphi.bazy-danych
Article #82835Re: SQL
From: konsul41
Date: Thu, 03 Aug 2017 09:07
Date: Thu, 03 Aug 2017 09:07
12 lines
1238 bytes
1238 bytes
Próbowałem tak SELECT generate_series(1,12) AS mies ,plan.id_srodektrwaly,plan.miesodpis from planamortyzacji AS plano LEFT JOIN (select miesiac,id_srodektrwaly, miesodpis from planamortyzacji where rok='2017' and id_srodektrwaly=16 and miesiac=plano.mies)AS plan ON plano.miesiac=plan.miesiac where rok='2017' order by mies ale w podzapytaniu nie mogę użyć plano.miesiac
Technical Details
Message-ID:
<olup48$ebf$1@portraits.wsisiz.edu.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!wsisiz.edu.pl!.POSTED.jue163.internetdsl.tpnet.pl!not-for-mailReferences:
<olulek$bh3$1@portraits.wsisiz.edu.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!wsisiz.edu.pl!.POSTED.jue163.internetdsl.tpnet.pl!not-for-mail From: "konsul41@wp.pl" <konsul41@wp.pl> Newsgroups: pl.comp.lang.delphi.bazy-danych Subject: Re: SQL Date: Thu, 3 Aug 2017 11:07:19 +0200 Organization: http://www.wit.edu.pl Message-ID: <olup48$ebf$1@portraits.wsisiz.edu.pl> References: <olulek$bh3$1@portraits.wsisiz.edu.pl> Mime-Version: 1.0 Injection-Date: Thu, 3 Aug 2017 09:07:20 -0000 (UTC) Injection-Info: portraits.wsisiz.edu.pl; posting-host="jue163.internetdsl.tpnet.pl:95.48.160.163"; logging-data="14703"; mail-complaints-to="abuse@wsisiz.edu.pl" User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:52.0) Gecko/20100101 Thunderbird/52.2.1 In-Reply-To: <olulek$bh3$1@portraits.wsisiz.edu.pl> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit