I have 3 tables, and Table1, Table2 and Table3 all have columns `Itemcode` and `Qty`.

I want write a query all itemcode from all tables with sum qty, but some items do not match both tables.

When I tried to write query with 

```
sum(tn2.sales + via1.sales + bcg.sales) 

```

I'm getting blank values.