Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> wrote: > and NOT EXISTS > (SELECT distinct mold.id from marinerstates Does that do better if you leave out the DISTINCT keyword? Maybeuse * instead of the column name? -Kevin