>Not exactly. The prupose of the query was to group records for all customers (returning one particular record for each one). It's old trick: group retains the last record, so data should be sorted first.

Ed, is this an old Foxpro trick, or an old ANSI-92 SQL trick? Can I upsize this technique and not get nasty surprises from MSSQL or Oracle because they do it differently? Thanks!