Select Where In Select

hjælp til at finde fejl i nedenstående

SELECT Sum(Quantity) AS AntalKoebte, ProductName, product.ProductID FROM shoppingbasket, product WHERE shoppingbasket.ProductID = product.ProductID AND Session IN (SELECT * FROM shoppingbasket, orders WHERE ProductID = 31 AND Session = SessionID) AND shoppingbasket.ProductID <> 31 GROUP BY ProductID ORDER BY AntalKoebte DESC


Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]Operand should contain 1 column(s)

/admin/stats/colect.asp, line 100