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@xxxxxxxxxxx