Execute multiple queries in single query using mysql [duplicate]

Question

I have two queries. One is gross sale and other is net sale. I want to report in a single query. How can I do that?

Gross Sale

Location Name                                     Gsale 
(sub-dealer-temp)                                   2   
2049 (Sub-Dealer) Always Protected, LLC             3   
2052 (Sub-Dealer) Alert Security, Inc               4   
2055 (Sub-Dealer) Alarm Connection, LLC             5   
2067 (Sub-Dealer-t) Activation Dept, LLC            67  
2068 (Sub-Dealer-t) Premier Security USA, LLC       8

Net Sale

location Name                                     Nsale 
2055 (Sub-Dealer) Alarm Connection, LLC             5   
2067 (Sub-Dealer-t) Activation Dept, LLC           67   
2068 (Sub-Dealer-t) Premier Security USA, LLC       8   
2783 ((Sub-Dealer-t) Premier abc                    45  
2783 ((Sub-Dealer-t) Premier xyz                    32

Result

Lc.Name                                Gsale             Nsale
(sub-dealer-temp)                        2               null
2049 (Sub-Dealer) Always Protected, LLC  3               null
2052 (Sub-Dealer) Alert Security, Inc    4               null
2055 (Sub-Dealer) Alarm Connection, LLC  5                5
2067 (Sub-Dealer-t) Activation Dept, LLC 67               67
2068 (Sub-Dealer-t) Premier Security US  8                8
2783 ((Sub-Dealer-t) Premier abc        null              45
2783 ((Sub-Dealer-t) Premier xyz        null              32

Hint: UNION

1000111
– 1000111

2016-10-04 07:48:16 +00:00
Commented Oct 4, 2016 at 7:48 — 1000111
– 1000111, Commented Oct 4, 2016 at 7:48

Shahrukh · Accepted Answer · 2016-10-04 07:55:39Z

0

you can use a join or union below is the join query

     select g.location,g.name,g.Gsale,n.Nsale from gross sale g 
     join net sale n on g.location=n.location

edited Oct 4, 2016 at 7:55

answered Oct 4, 2016 at 7:50

Shahrukh

1025 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Drew Over a year ago

please learn to format a vertical block. Thx

Razib Al Mamun · Accepted Answer · 2016-10-04 16:32:19Z

0

You can use bellow sql code:

Table name 1 : Gross Sale is now gross_sale and column name lcName, Gsale

Table name 2 : Net Sale is now net_sale and column name lcName, Nsale

SELECT a.lcName, a.Gsale, b.Nsale FROM gross_sale a 
FULL OUTER JOIN net_sale b ON a.lcName=b.lcName ORDER BY a.lcName;

edited Oct 4, 2016 at 16:32

answered Oct 4, 2016 at 8:05

Razib Al Mamun

2,7111 gold badge18 silver badges24 bronze badges

4 Comments

Drew Over a year ago

you want a full outer join not a left join right? See the column Gsale?

Razib Al Mamun Over a year ago

@Drew can you explain clearly?

Drew Over a year ago

What does a left join do?

Razib Al Mamun Over a year ago

@Drew Sorry for that, yes it will FULL OUTER JOIN.

Collectives™ on Stack Overflow

Execute multiple queries in single query using mysql [duplicate]

2 Answers 2

1 Comment

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Linked

Related