If you're just seeing if the customerid exists in the other table shouldn't this be an EXISTS clause? No need to return the results of the subquery just see if...