RE: Can we have a Key fld from 2nd file in Join Logical

Thanks - I must have confused this with the ORDER BY of
a SELECt, where you can sort across the result set.
What's the best set of indexes, then, for such a
statement?
>
> vhamberg wrote:
> > An index could be built over a join view and have key fields from
> wherever.
>
> No, an index can only be created over a table.
>
> Best regards
> Richard THEIS
>  AS/400 Education, France
>   theis_richard@fr.ibm.com
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>