I want to do a query like this, but

[cocoadev]

I want to do a query like this, but mysql doesn't want to know...

SELECT size.sizes FROM size, details WHERE details.productID = (SELECT details.productID FROM product, details WHERE product.combocode = 5 AND product.productID = details.productID) AND (size.sizeID = details.sizeID)

the child query returns two varchar(9) productID's  , because it return a table with two, would that be the problem?

If i remove the child query, and replace it with the fetched productID "QW118" it works fine.

Any help would be great, thanks, ben

MySQL said:
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 details.productID
FROM product, details
WHERE product.co

 

[hos2]

WHERE details.productID IN (SELECT  details.productID     FROM  product, details  WHERE product.combocode = 5 AND product.productID = details.productID)

use IN instead of =

 

[spookie]

Ur tring a 'sub select' or 'nested query' , which is not supported by older versions of MySQL.

If u r using a server side language u can have multiple queries (in a loop) to have the outout u wanted.


--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[hos2]

in that case you can look at

thread436-695290 a workaround with older mysql versions