Query Conversion MS to MYSQL

[Shane Menshik]

I have an sql query that worked on MS SQL 2000.. I need to know what the mysql version needs to look like..

the MS sql query is as such:

Select CARTS.CARTNUMBER, CARTS.UNITPRICE, QUANTITY = (Select SUM(numitems) from selitems where SELITEMS.CARTNUMBER = CARTS.CARTNUMBER)

basicly thats an example of what im talking about.. It works in MS SQL but in mysql the same query gives me the error: "Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Select SUM(numitems) from selitems where SELITEMS.CARTNUMBER"

Does mysql support this using a different method? I'm trying to assign the quanity alias to the value of the total number of items assigned to the paticular cart..


Thanks!

Shane