WHERE clause on JOIN query???

[Mincer]

I have this query:

$sql = "
	SELECT unbilled_item.job_number,
	SUM(unbilled_item.amount) AS total_unbilled,
	job.project_manager
	FROM unbilled_item
	LEFT JOIN job ON (unbilled_item.job_number=job.job_number)
	GROUP BY job.project_manager
	ORDER BY total_unbilled DESC
	" ;

Is it possible to add something like:

WHERE user.office = "xxx"

???

I can't work it out.

[DaveMaxwell]

You would need to add the user table to the query, of course, and you would probably need to rework the query a bit, but it should be possible....

[Mincer]

It's OK, today's query of the day is:

$sql = "
	SELECT
	SUM(unbilled_item.amount) AS total_unbilled,
	user.office,
	user.first_name,
	user.surname
	FROM job
	LEFT JOIN unbilled_item ON (job.job_number=unbilled_item.job_number)
	LEFT JOIN user ON (job.project_manager=user.employee_number)
	WHERE user.office = $office
	GROUP BY job.project_manager
	ORDER BY total_unbilled DESC
	" ;