Join multipule select statements

[jayfacc]

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]

[JustLikeIcarus]

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;

[JustLikeIcarus]

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;

[jayfacc]

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!