Rick Osborne On Database Indexing And SQL Best Practices 

FROM
	contact c
INNER JOIN
	job j
ON
(
		c.is_deleted = 0
	AND
		c.id = j.contact_id
	AND
		j.is_deleted = 0
	AND
		j.contact_role_id = #ContactRoles.CEO#
)

For Cut-and-Paste