Re: SQL

Article View: pl.comp.lang.delphi.bazy-danych

Article #82836

Back to pl.comp.lang.delphi.bazy-danych Previous Next

#82836

From: konsul41
Date: Thu, 03 Aug 2017 09:25

8 lines
1250 bytes

Chyba znalazłem

SELECT generate_series::numeric,id_srodektrwaly::numeric,miesodpis::numeric
   FROM generate_series(1,12)
   LEFT JOIN (select miesiac::numeric,id_srodektrwaly::numeric, 
miesodpis::numeric from planamortyzacji where rok='2017' and 
id_srodektrwaly=57)AS plan ON plan.miesiac =generate_series

Technical Details

Message-ID: <oluq67$f6a$1@portraits.wsisiz.edu.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!wsisiz.edu.pl!.POSTED.jue163.internetdsl.tpnet.pl!not-for-mail

References: <olulek$bh3$1@portraits.wsisiz.edu.pl> <olup48$ebf$1@portraits.wsisiz.edu.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.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:25:26 +0200
Organization: http://www.wit.edu.pl
Message-ID: <oluq67$f6a$1@portraits.wsisiz.edu.pl>
References: <olulek$bh3$1@portraits.wsisiz.edu.pl> <olup48$ebf$1@portraits.wsisiz.edu.pl>
Mime-Version: 1.0
Injection-Date: Thu, 3 Aug 2017 09:25:27 -0000 (UTC)
Injection-Info: portraits.wsisiz.edu.pl; posting-host="jue163.internetdsl.tpnet.pl:95.48.160.163"; logging-data="15562"; 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: <olup48$ebf$1@portraits.wsisiz.edu.pl>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message