Urgent Query Syntax | SQL SERVER
Source Table Name :- CLI
Field Name :- AMOUNT
Business Rule
SELECT SUM(AMOUNT) AS B
FROM Test1 CL , Test2 CH, Test3 SH WHERE CH.NO = CL.NO AND SH.NO = CH.ORDER_NO
group by no
Target Table:- SERVICE
Field Name :- AMOUNT_PC
Field Name :- AMOUNT
Business Rule
SELECT SUM(AMOUNT) AS B
FROM Test1 CL , Test2 CH, Test3 SH WHERE CH.NO = CL.NO AND SH.NO = CH.ORDER_NO
group by no
Target Table:- SERVICE
Field Name :- AMOUNT_PC
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER