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_BUSINE SS_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_BUSINE SS_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
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_BUSINE
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_BUSINE
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sam2929, do you still need help with this question?
WHERE D5.NO = '102161'
So just use INNER JOIN instead