<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	Exploring The Cardinality And Selectivity Of SQL Conditions
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:1424.view
	
	Date Posted:
	Dec 8, 2008 at 3:14 PM
	
---- --------------------------------------------------------------------------------------- --->


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_id = #FORM.contact_id#
		AND
			j.contact_role_id = #ContactRoles.CEO#
		AND
			j.date_started <= NOW()
		AND
			(
					j.date_ended IS NULL
				OR
					j.date_ended > NOW()
			)
	)