On Wed, 19 Jan 2022 06:32:19 -0700, Rob Sargent wrote:
>
>> No it does not...but I assume it lists products that where at least
>> ordered before January 1st 2021
>> as it contains lower product IDs.
>>
>> Hmm..gives me:
>>
>>> ERROR: function max(boolean) does not exist
>> LINE 5: having max(o.orderdate < '2021-01-01')
>>
>>
> Sorry
>>
>> max(o.orderdate )< '2021-01-01'
>
>>
You're a genius :-)
Looks perfect...
kiitoksia
richard