Hi,
Check the below Query....
SELECT T.GodownId,
T.Activity,
T.Time,
T.Qty,
T.Amount,
(T.Qty*T.Amount) 'CalculatedAmount'
FROM (SELECT T1.GodownId,T1.Activity,T1.Time,T1.Qty,
(CASE WHEN T1.Activity='Loading' AND T1.Time='Day' THEN T2.LoadingDayRate
WHEN T1.Activity='Loading' AND T1.Time='Night' THEN T2.LoadingN8Rate
WHEN T1.Activity='Unloading' AND T1.Time='Day' THEN T2.UnloadingDayRate
WHEN T1.Activity='Unloading' AND T1.Time='Night' THEN T2.UnloadingN8rate
WHEN T1.Activity='Crossing' AND T1.Time='Day' THEN T2.CrossingDayRate
WHEN T1.Activity='Crossing' AND T1.Time='Night' THEN T2.CrossingNightRate
ELSE 0 END) 'Amount'
FROM First_Table T1
INNER JOIN Second_Table T2 On T2.GodownId=T1.GodownId) T
Regards,
GVPrabu