Hi
Here's a complicated bit sql that I'm trying to Post from MSAccess to
MySql
I searched UseNet and read that in MySQL you cannot have a sub-select,
but I'm lost as to how to split this into two selects?
Any help gratefully received!!!
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)
--
vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?"
http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
