- - i have two select statment , first one `( select b.id AS bnamee from branch b )`
- and the second one ( SELECT MAX (TOTAL ) AS fs2 , b.id as bname FROM ( select sum(sa.num * pq.points ) AS TOTAL , b.id as bname
FROM AGENT AG , SALESFACT SA , productsquarter PQ , BRANCH B
WHERE
AG.branch_id = b.id
AND
pq.quarter_id = 'Q1_16'
AND
sa.month = 'JAN'
AND sa.qp_id = pq.id
AND b.are_id = 'AP1'
AND ag.agent_id = sa.agent_id
GROUP BY b.id , b.are_id ) , branch b group by b.id
)b
- when i am using the inner join it gave me this ruselt
T2 5759
DT1 5759
SH2 5759
T1 5759
DT2 5759
SH1 5759
however the correct result must be
T1 5759
so any advise