Link to home
Start Free TrialLog in
Avatar of sam2929
sam2929

asked on

Join two query to make it one

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
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
both Q1 & Q2

LEFT OUTER JOIN dbo.D_BUSINESS D5 ON F.FK_ACCNT_ID = D5.SK_BUSINESS_ID
WHERE D5.NO = '102161'
There is no benefit to you in using that LEFT OUTER JOIN because every row MUST have D5.NO = '102161'

So just use INNER JOIN instead
sam2929, do you still need help with this question?