como hago esta consulta.

[Aztaroth]

Ya probaste agrupando

SELECT DISTINCT DETTRA.* FROM DETTRA WHERE SERIE='P' AND CANREC = 0 and fecha >= '09/01/2004' and fecha<= '09/30/2004' ORDER BY TIENDA,TDAORI group by [Campos]