jayfacc Posted December 7, 2009 Share Posted December 7, 2009 I want to join the below two select statements to get the desiredoutput.jpg attached. output.jpg is what each statement gives me now (dummy data). How would I do this as it's the same table. Thanks in advance! SELECT store,banner,store_city,store_postal, SUM(latest_ytd), SUM(yag_ytd) FROM table1 WHERE measurement = "$ Sales Total" GROUP BY store; SELECT store,banner,store_city,store_postal, SUM(latest_ytd), SUM(yag_ytd) FROM table1 WHERE measurement = "Quantity Total" GROUP BY store; [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/184232-join-multipule-select-statements/ Share on other sites More sharing options...
JustLikeIcarus Posted December 7, 2009 Share Posted December 7, 2009 How about this? SELECT store,banner,store_city,store_postal, SUM(t1.latest_ytd), SUM(t1.yag_ytd), SUM(t2.latest_ytd), SUM(t2.yag_ytd) FROM table1 t1, table1 t2 WHERE t1.store = t2.store AND t1.measurement = 'Quantity Total' AND t2.measurement = '$ Sales Total' GROUP BY t1.store; Link to comment https://forums.phpfreaks.com/topic/184232-join-multipule-select-statements/#findComment-972950 Share on other sites More sharing options...
JustLikeIcarus Posted December 7, 2009 Share Posted December 7, 2009 Actually better yet try. SELECT store,banner,store_city,store_postal, SUM(if(measurement = 'Quantity Total', latest_ytd, 0)), SUM(if(measurement = 'Quantity Total',yag_ytd, 0)), SUM(if(measurement = '$ Sales Total', latest_ytd, 0)), SUM(if(measurement = '$ Sales Total', yag_ytd, 0)) FROM table1 GROUP BY store; Link to comment https://forums.phpfreaks.com/topic/184232-join-multipule-select-statements/#findComment-972958 Share on other sites More sharing options...
jayfacc Posted December 7, 2009 Author Share Posted December 7, 2009 Actually better yet try. SELECT store,banner,store_city,store_postal, SUM(if(measurement = 'Quantity Total', latest_ytd, 0)), SUM(if(measurement = 'Quantity Total',yag_ytd, 0)), SUM(if(measurement = '$ Sales Total', latest_ytd, 0)), SUM(if(measurement = '$ Sales Total', yag_ytd, 0)) FROM table1 GROUP BY store; Thank you so much! Works like a charm! Link to comment https://forums.phpfreaks.com/topic/184232-join-multipule-select-statements/#findComment-973024 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.