On 7/19/21 11:58 AM, Rich Shepard wrote:
> On Mon, 19 Jul 2021, Adrian Klaver wrote:
>
>> Is there a reason you can't just restrict the query to the columns you
>> want?
>
> Adrian,
>
> As far as I know I need to specify FK and PK columns when tables are
> joined;
You need them in the JOIN and/or WHERE sections, but not necessarily in
the field list in the SELECT portion.
> I don't need those key columns in the output.
>
> Thanks,
>
> Rich
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com