This query will do the trick.

Thanks all for your help.

SELECT *

FROM wellprod t1

WHERE EXISTS

(

SELECT 1

FROM

(

...

Here is some sample data. The records with the "*" at the end are the ones I want the query to return. (ie. the first 3 records, if...