[McDuck]

I have yhe same problem.

I have MySQL version 4.0.0 and I want to execute the following query:

SELECT a.* FROM al_assets a

INNER JOIN al_asset_details b on a.asset_id = b.asset_id

WHERE

b.name=”color_code”

AND b.value = “0308”

AND a.asset_id in (

SELECT a.asset_id from al_assets a

INNER JOIN al_asset_details b on a.asset_id = b.asset_id

WHERE b.name=”product_code” AND b.value = “571432”)

and I get error message:

Error Code : 1064

You have an error in your SQL syntax near 'select `a.asset_id` from `al_assets` a inner join al_asset_details b on a.asset_' at line 6

Why does the query not work? Anyone?

I have tried to replace the word IN with = sign but, that results in the same message

[Author]

Posts