Jump to content

Join multipule select statements


jayfacc

Recommended Posts

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

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;

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;

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!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.