>The second query wouldn't optimise the referral table because you are selecting all the records from the referral table where they match records records in sclient tab so all referral records have to be checked

Nick

Thanks, that's all I needed to know.

Kev