[SOLVED] Subquery problem

[CaptainChainsaw]

Hi all,

 

I have the following subquery:

 

SELECT user_cart.description, user_cart.prod_desc_id, user_cart.location, prod_desc.Style_Number, prod_desc.Colour_Code FROM user_cart, (SELECT Style_Number, Colour_Code FROM prod_desc, user_cart, user_order WHERE prod_desc.prod_desc_id=user_cart.prod_desc_id AND user_cart.user_order_id=user_order.user_order_id AND user_order.user_order_id=1155) as prod_desc WHERE user_order_id=1155 

 

 

This displays 4 rows when it should only display 2.  Each SELECT statement on its own returns 2 queries, combining them like this results in 4 rows.  The records have been duplicated.

 

Any idea what I need to do to fix this?

 

 

 

Thnx in advance,

 

 

CC

[CaptainChainsaw]

I've fixed this prob, didn't need a subquery

[fenway]

I've fixed this prob, didn't need a subquery

That's nice... please post the revised query.