Dear Sir/Madam
I Have Two Table of Transport Rates
1) TableA
Contains Rate from X to Location
Location Prices
A 11
B 22
C 33
D 44
E 55
F 66
G 77
2) TableB
Location Prices
A 88
B 99
H 111
I 222
J 333
K 444
After Query Result I require is
Location PricesA PricesB PriceDiff A-B (If A is Null Take it as 0)
A 11 88
B 22 99
C 33 ---
D 44 ----
E 55 ----
F 66 -----
G 77 ----
H ---- 111
I ----- 222
J ----- 333
K ---- 444
Thanks in Advance
Rahul