We help IT Professionals succeed at work.
Get Started

Join two query to make it one

105 Views
Last Modified: 2015-03-26
Hi,

I have two query

query 1)

select
d5.NO,
d.TYPE_CD_ENU,
d5.BUS_NM,
SUM(f.QTY),
D5.BUSINESS_ID
 from F_QTY f
LEFT OUTER JOIN D_JUNK d
on f.FK_JUNK_ID=d.SK_JUNK_ID
LEFT OUTER JOIN dbo.D_BUSINESS d5
on f.FK_ACCNT_ID=d5.SK_BUSINESS_ID
WHERE d5.NO ='102161'
group by
d5.EICB_NO,
d.TYPE_CD_ENU,
d5.BUS_NM,
d5.BUSINESS_ID

query 2)

select
e.Shift,
e.Return,
e.BUS_NM,
e.BUSINESS_ID
 from F_ACCT f
LEFT OUTER JOIN D_ACC_JUNK e
on f.FK_JUNK_ID=d.SK_JUNK_ID
LEFT OUTER JOIN dbo.D_BUSINESS d5
on f.FK_ACCNT_ID=d5.SK_BUSINESS_ID
WHERE d5.NO ='102161'

Now join query 1) and query 2)

to get below we can use BUSINESS_ID to join them

d5.NO,
d.TYPE_CD_ENU,
d5.BUS_NM,
SUM(f.QTY),
D5.BUSINESS_ID,
e.Shift,
e.Return,
e.BUS_NM,
e.BUSINESS_ID
Comment
Watch Question
Senior DBA
CERTIFIED EXPERT
Most Valuable Expert 2018
Distinguished Expert 2019
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE