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 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 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. Link to comment https://forums.phpfreaks.com/topic/134486-solved-subquery-problem/#findComment-700975 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.