Help With a Query!! (Please...)

[D.Smith]

Hi

I am working on porting a db from MS$QL to mysql

This query works in SQL Server, but not in mysql. It seems to be the final
line where I do a sub-query, because if I comment that out it runs fine.
Anyone know why??

Thanks...

SELECT Course.Name AS className,
Course.ID AS courseID,
Course.shortName,
Course.Description,
Course.filename,
Class.Status,
Class.ID AS classID,
Class.StartDate,
Class.EndDate,
Class.Location,
Class.StudentMax,
Class.tuition + Class.Materials AS totalCost,
Class.Materials ,
Class.tuition,
Class.Length,
CONCAT( AgeLevels.minimumAge , ' ' , AgeLevels.minUnits ,
' to ' , AgeLevels.maximumAge , ' ' , AgeLevels.maxUnits) AS AgeLevels ,
total = (SELECT COUNT(*) FROM StudentClasses)
FROM Course
INNER JOIN Class ON Class.CourseID = Course.ID
LEFT OUTER JOIN AgeLevels ON Course.AgeLevels = AgeLevels.ID

[Aggro]

D.Smith wrote:

This query works in SQL Server, but not in mysql. It seems to be the final
line where I do a sub-query, because if I comment that out it runs fine.
Anyone know why??

Subqueries are supported from version >= 4.1 Perhaps that is the reason?
You didn't mention what version you are using.

[Aggro]

D.Smith wrote:

This query works in SQL Server, but not in mysql. It seems to be the final
line where I do a sub-query, because if I comment that out it runs fine.
Anyone know why??

Subqueries are supported from version >= 4.1 Perhaps that is the reason?
You didn't mention what version you are using.

[Aggro]

D.Smith wrote:

This query works in SQL Server, but not in mysql. It seems to be the final
line where I do a sub-query, because if I comment that out it runs fine.
Anyone know why??

Subqueries are supported from version >= 4.1 Perhaps that is the reason?
You didn't mention what version you are using.