Here's another rotter!
I searched UseNet and read that in MySQL you cannot have a sub-select,
That's old information. Subqueries are supported as of MySQL 4.1.
You'll probably need some quotes around the values in your BETWEEN expression, though.
but I'm lost as to how to split this into two selects?
SELECT distinct p.ProjectID ,p.ProjectName FROM tbl_project AS p
INNER JOIN
(
(
(tbl_UnitType AS ut INNER JOIN tbl_RateType AS r ON ut.RateType
= r.RateType)
INNER JOIN (tbl_SubProject AS sp
INNER JOIN (Select * FROM tbl_ProjectResource
WHERE UserID = '#rptUserID#'
AND Deleted = 0
AND ((ActivityDate) Between #datDateFrom# And
#datDateTo#) ) AS pr ON sp.SubProjectID = pr.SubProjectID)
ON ut.Unit = pr.Unit
) INNER JOIN tbl_RateTypeCategoryCharge AS rt ON
pr.RateTypeCategoryChargeID = rt.RateTypeCategoryChargeID
) ON p.ProjectID = sp.ProjectID
WHERE ut.reportDisplay = 1
zzapper (vim, cygwin, wiki & zsh)
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
