Path: news.f.de.plusline.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!transit4.news.xs4all.nl!transit.news.xs4all.nl!xs4all!textnews.nntp.hccnet.nl!textreader.nntp.hccnet.nl!not-for-mail From: sybrandb@hccnet.nl Newsgroups: comp.databases.oracle.tools Subject: Re: Help with building an Oracle View for Crystal Reports Date: Tue, 24 Apr 2007 20:47:12 +0200 Message-ID: <14ks239o8cfqjid884dsr2ff41hrn7cgbh@4ax.com> References: <1177439547.970757.45200@t38g2000prd.googlegroups.com> X-Newsreader: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 12 Organization: Hobby Computer Club News Network NNTP-Posting-Date: 24 Apr 2007 18:47:18 GMT NNTP-Posting-Host: 62.251.43.163 X-Trace: 1177440438 textreader.nntp.hccnet.nl 734 62.251.43.163:3105 X-Complaints-To: abuse@hccnet.nl Xref: news.f.de.plusline.net comp.databases.oracle.tools:35645 On 24 Apr 2007 11:32:28 -0700, "cory.swartz" wrote: >I'm not sure if this is more Crystal related or a problem with my >Oracle view I created... here is the view script: Just lousy database design and lack of SQL knowledge. Please look up OUTER JOIN in the documentation. -- Sybrand Bakker Senior Oracle DBA