Re: Fwd: garbage data back

[Adrian Klaver]

On 3/6/23 12:48 PM, Brad White wrote:

LOL

Joke's on me.

Here's the relevant part of the view

SELECT ...
     "Order Items"."ID" AS "OrderItemID",
     ...
     (("Orders"."ID" || '-'::text) || "Order Items"."ID") AS "FileKey"\

Because "Orders"."ID"  is different then "Order Items"."ID"?

Wait, then why are the Item IDs different?

--
Adrian Klaver
adrian.kla...@aklaver.com