Article View: pl.comp.bazy-danych
Article #195132Re: [DB2] - złączenie trzech dziwnych tabel
From: KA-RAM-BA
Date: Mon, 21 Nov 2016 13:27
Date: Mon, 21 Nov 2016 13:27
15 lines
1798 bytes
1798 bytes
> powinno dać to czego pragniesz: > > select o.im, o.nz > , max(d.dt) d_dt > , case when max(p.dt) > max(d.dt) then max(p.dt) end p_dt > from osoby o > left join dokumenty d > on o.pesel = d.pesel > left join pisma p > on o.pesel = p.pesel > and p.dt > d.dt > group by o.psl, o.im, o.nz; > Wielkie dzięki, działa. O to mi chodziło. Potrzebuję wyciągnąć dane do statystyk na bieżąca chwilę więc to mi w zupełności wystarczy.
Technical Details
Message-ID:
<4b6083cd-7831-409a-953a-9c6d631ac7d4@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!o1no1367343ito.0!news-out.google.com!k2ni2896itb.0!nntp.google.com!o1no1367341ito.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<83f95368-e17c-4df6-a2d7-d2e9695c87ba@googlegroups.com> <58217a1a$0$5154$65785112@news.neostrada.pl>Show Full Headers
Complete Article Headers
X-Received: by 10.157.46.106 with SMTP id c39mr5278712otd.106.1479734850426; Mon, 21 Nov 2016 05:27:30 -0800 (PST) X-Received: by 10.157.40.215 with SMTP id s81mr750617ota.7.1479734850395; Mon, 21 Nov 2016 05:27:30 -0800 (PST) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!o1no1367343ito.0!news-out.google.com!k2ni2896itb.0!nntp.google.com!o1no1367341ito.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych Date: Mon, 21 Nov 2016 05:27:30 -0800 (PST) In-Reply-To: <58217a1a$0$5154$65785112@news.neostrada.pl> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=79.187.69.101; posting-account=SplkzQoAAABnRhCOmXNQipLBrNwKM079 NNTP-Posting-Host: 79.187.69.101 References: <83f95368-e17c-4df6-a2d7-d2e9695c87ba@googlegroups.com> <58217a1a$0$5154$65785112@news.neostrada.pl> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <4b6083cd-7831-409a-953a-9c6d631ac7d4@googlegroups.com> Subject: Re: [DB2] - złączenie trzech dziwnych tabel From: KA-RAM-BA <ka-ram-ba@wp.pl> Injection-Date: Mon, 21 Nov 2016 13:27:30 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit