Re: Views and Inner join

IMHO, there is no reason to mix technologies. If you are going to use SQL, then you should use tables, views and indexes, not PF and LF. Tables are essentially the same as PF (mostly), but there is not really a direct correlation between LF and either indexes or views. Yes IBM has added some extensions to make it easier for holdouts to use SQL to do exactly what you can do in DDS, but what is the point? Use SQL as it was designed to be used. DML should reference only Tables and Views, with Indexes created to improve performance. There should be no LF references at all in your DML, it is unnecessary, and in some ways counterintuitive. For example, using a LF in a select will not cause the SQL to return records based on the LF sort sequence! The only way to guarantee a given sort sequence on a select is to put in an order by. The optimizer will still select the best access path based on the DML, and it might or might not be the LF that you specified.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Crystal Reports <crystalcleardecisions@xxxxxxxxx> wrote: -----
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
From: Crystal Reports <crystalcleardecisions@xxxxxxxxx>
Date: 05/29/2013 07:39PM
Subject: Views and Inner join

Can you do an inner join on Views? Also it seems you cannot use a Logical in Views.