Aggregation Error Message

Hi cheid_4838 ,

It looks like you're running into an issue with using an aggregate function ('MAX()') directly in the 'WHERE' clause, which is not permitted in SQL. Please update your SQL statement as below and check if it can work or not...

SELECT s.cmp_id AS ReceiverID
FROM stops s (nolock)
JOIN (
    SELECT ord_hdrnumber, MAX(stp_sequence) AS max_sequence
    FROM stops
    WHERE stp_event IN ('LUL', 'LLD', 'DRL', 'HPL')
    GROUP BY ord_hdrnumber
) max_stops
ON s.ord_hdrnumber = max_stops.ord_hdrnumber
   AND s.stp_sequence = max_stops.max_sequence

Best Regards