Article View: pl.comp.lang.java
Article #151114Re: JPA Query, relacja OneToMany
From: Witold Szczerba
Date: Thu, 23 Sep 2010 22:11
Date: Thu, 23 Sep 2010 22:11
9 lines
1779 bytes
1779 bytes
On Sep 22, 8:32 am, "William Bonawentura" <n...@ipartners.pl> wrote: > >może teraz będzie łatwiej przepisać takie zapytanie na JPA QL. > > IMHO zapytanie SQL które podałeś (z group by) nie jest równoważne temu z > subselectem bo nie zwróci faktur bez pozycji OK, więc jak zamienisz JOIN na LEFT JOIN to zwróci także te bez pozycji.
Technical Details
Message-ID:
<d4b7381b-6f1e-4e5c-b791-2bede48211dd@e20g2000vbn.googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!plix.pl!newsfeed1.plix.pl!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!bandi.nntp.kabelfoon.nl!198.186.194.249.MISMATCH!news-out.readnews.com!transit3.readnews.com!postnews.google.com!e20g2000vbn.googlegroups.com!not-for-mailReferences:
<i6vb44$1m14$1@news2.ipartners.pl> <i727ov$5ci$1@usenet.news.interia.pl> <i76s21$1pgs$1@news2.ipartners.pl> <2bf86152-b3a6-41a1-b22d-ff4779df2388@c13g2000vbr.googlegroups.com> <i7c7u4$17r0$1@news2.ipartners.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!plix.pl!newsfeed1.plix.pl!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!bandi.nntp.kabelfoon.nl!198.186.194.249.MISMATCH!news-out.readnews.com!transit3.readnews.com!postnews.google.com!e20g2000vbn.googlegroups.com!not-for-mail From: Witold Szczerba <pljosh.mail@gmail.com> Newsgroups: pl.comp.lang.java Subject: Re: JPA Query, relacja OneToMany Date: Thu, 23 Sep 2010 15:11:22 -0700 (PDT) Organization: http://groups.google.com Lines: 10 Message-ID: <d4b7381b-6f1e-4e5c-b791-2bede48211dd@e20g2000vbn.googlegroups.com> References: <i6vb44$1m14$1@news2.ipartners.pl> <i727ov$5ci$1@usenet.news.interia.pl> <i76s21$1pgs$1@news2.ipartners.pl> <2bf86152-b3a6-41a1-b22d-ff4779df2388@c13g2000vbr.googlegroups.com> <i7c7u4$17r0$1@news2.ipartners.pl> NNTP-Posting-Host: 79.186.33.218 Mime-Version: 1.0 X-Trace: posting.google.com 1285279883 25481 127.0.0.1 (23 Sep 2010 22:11:23 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 23 Sep 2010 22:11:23 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: e20g2000vbn.googlegroups.com; posting-host=79.186.33.218; posting-account=gnHnDQoAAABAt-cdgg6OG0gvpEhXZTSx User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.9) Gecko/20100825 Ubuntu/10.04 (lucid) Firefox/3.6.9,gzip(gfe) Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit