<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	Rick Osborne On Database Indexing And SQL Best Practices
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:1423.view
	
	Date Posted:
	Dec 8, 2008 at 9:01 AM
	
---- --------------------------------------------------------------------------------------- --->


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#
)