<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	Why My Queries Hate Application Service Layers
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:1614.view
	
	Date Posted:
	Jun 18, 2009 at 10:02 AM
	
---- --------------------------------------------------------------------------------------- --->


SELECT
	a.id,
	a.name,
	a.filename,
	a.project_id,
	( p.name ) AS project_name
FROM
	asset a
INNER JOIN
	project p
ON
	(
			a.id = #asset_id#
		AND
			p.id = #project_id#
		AND
			a.project_id = p.id
	)