Re: Pls correct SQL - Urgent

KK, the first query is not returning duplicates as you claim. Each recored is unique. Your problem is that all the data is the same except for the last column selected which returns one column equal to 'success' and one equal to 'failure'.

In your note later you state what you want for a return list from the first query but you do not state the criteria for determing that the success or failure row should be returned. Something like you want the last action, first action, count of successes and failures for each activity etc....

HTH -- Mark D Powell -- Received on Tue Jul 19 2005 - 09:39:30 CDT