SQL查询报告 [英] SQL Query for Report
问题描述
大家好,
我有三张桌子如下链接
表A
PersonId,Code
123314 ABC
456788 ABC
878788 ABC
987878 CDE
025455 CDE
表B
PersonId,Extn
123314 8888
456788 9878
878788 9999
987878 1010
025455 1111
表C
Extn LocalCost STDCost ISDCost日期
8888 10 15 10 1-Jul
9878 20 30 12 1- Jul
1010 15 12 20 1-Jul
1010 10 10 10 2-Jul
1010 10 10 10 2-Jul
A.PersonId = B.PersonId
B.Extn = C.Extn
来自我需要三个表格结果如下
代码LocalCost STDCost ISDCOst TOTAlCOst
ABC 30 45 22 97
CDE 25 27 30 82 >
我需要简单的SQl查询来实现这个
谢谢
Mohan
Hi All,
I have three tables linking with each other like below
TABLE A
PersonId, Code
123314 ABC
456788 ABC
878788 ABC
987878 CDE
025455 CDE
TABLE B
PersonId, Extn
123314 8888
456788 9878
878788 9999
987878 1010
025455 1111
TABLE C
Extn LocalCost STDCost ISDCost Date
8888 10 15 10 1-Jul
9878 20 30 12 1-Jul
1010 15 12 20 1-Jul
1010 10 10 10 2-Jul
1010 10 10 10 2-Jul
A.PersonId=B.PersonId
B.Extn=C.Extn
from these three tables i need result as below
Code LocalCost STDCost ISDCOst TOTAlCOst
ABC 30 45 22 97
CDE 25 27 30 82
I Need simple SQl Query to achive this
Thanks
Mohan
推荐答案
您好,
试试这个...
Hi,
Try this...
SELECT Code, LocalCost, STDCost, ISDCOst, LocalCost+STDCost+ISDCOst AS TOTAlCOst
FROM TABLE_A A, TABLE_B B, TABLE_C C
WHERE A.PersonId=B.PersonId
AND B.Extn=C.Extn
< br $> b $ b
希望你能得到所需的输出。
>
干杯
这篇关于SQL查询报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!