I just wanted to add different columns from different tables... Has anyone any idea on how to do that?

Consider I have 3 tables as below

1. tv sales
2. AC sales
3. cooler sales

And the tables data as follows

1)Tv Sales

```
   Id    Date        NoOfSales   Totalamount

    1    03/05/2014     10         10000
    2    04/05/2014     20         20000
    3    05/05/2014     30         30000

```

2)Ac Sales

```
   Id    Date        NoOfSales   Totalamount

   1    03/05/2014     10         50000
   2    04/05/2014     20         60000
   3    05/05/2014     30         70000

```

3)cooler Sales

```
   Id    Date        NoOfSales   Totalamount

   1    03/05/2014     10         30000
   2    04/05/2014     20         60000
   3    05/05/2014     30         70000

```

Now I want to add the "Totalamount" from all the tables for a particular "date"
for example I need totalamount on 03/05/2014 as 90000