Multiply within Select Query
I have a two tables, say ZTAB1 and ZTAB2. ZTAB1 has fields node1 and node2. ZTAB2 has fields node3.
By using simple select query we can fetch the data from the DB tables. But the complexity is that I want another field in second table say node4 and the value in it should be ( Node2 * 10 ).
I know that we can do it by looping the internal tables and performing arithmetic operations and modifying.
As the table ZTAB1 and ZTAB2 has a bulk amount of records, it would be a performance issue for the code I loop and modify. Can we achieve it within select query itself.
( a~node2 * 10) as b~node4 into ITAB
from ZTAB1 AS a
INNER JOIN ZTAB2 AS b