Order By Syntax Issue

[son]

I cannot get the ORDER BY syntax right on my query. I have:

SELECT product_id, product, img1 FROM products WHERE product_id IN (SELECT product_id FROM productCat WHERE category_id = 9)  ORDER BY (SELECT usort FROM productCat)

Products should be ordered by the column usort in productCat table. How would I do this correctly?Son

[justsomeguy]

You need to join with the productCat table and then you can use it to order.

[son]

You need to join with the productCat table and then you can use it to order.

I did try this before, but had also no luck. PhpMyAdmin says that there is also a mistake in my syntax (near ORDER clause). I had:

SELECT products.product_id, product, img1, productCat.usort FROM products, productCat WHERE (products.product_id = productCat.product_id) AND productCat.category_id = 9)  ORDER BY productCat.usort

Son

[justsomeguy]

The parentheses don't match up.

[son]

The parentheses don't match up.

Again, just such a simple thing I overlooked. Sometimes I worry about my concentration;-)Many thanks,Son