>Hi All,
>
>I need to list (cursor/tmp file /whatever)
>of duplicates in a table.
>
>There are 2 fields when combined will form the duplicate key value.
>SALESDATE + TRIP_NO.
>
>I can do this with MS-SQL 6.0 but in FOXPRO the SYNTAX seems to
>have me stumped.
>
>Can anybody help?
>
>John King
>tola@dbn.lia.net
John,

select * from mytable ;
  where (SALESDATE + TRIP_NO) in ;
  (select SALESDATE + TRIP_NO ;
     from mytable ;
     having cnt(*) > 1 ;
     group by 1)

Cetin