CaptainChainsaw Posted November 27, 2008 Share Posted November 27, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/134486-solved-subquery-problem/ Share on other sites More sharing options...
CaptainChainsaw Posted November 27, 2008 Author Share Posted November 27, 2008 I've fixed this prob, didn't need a subquery Quote Link to comment https://forums.phpfreaks.com/topic/134486-solved-subquery-problem/#findComment-700274 Share on other sites More sharing options...
fenway Posted November 28, 2008 Share Posted November 28, 2008 I've fixed this prob, didn't need a subquery That's nice... please post the revised query. Quote Link to comment https://forums.phpfreaks.com/topic/134486-solved-subquery-problem/#findComment-700975 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.