I have tables that looks like this:-

**tblConsuptionsFromA**

> 
> id  meter        date        total  
> 
>  1      1      03/01/2014  100.1  
> 
>  2      1      04/01/2014  184.1  
> 
>  3      1      05/01/2014  134.1  
> 
>  4      1      06/01/2014  132.4  
> 
>  5      1      07/01/2014  126.1  
> 
>  6      1      08/01/2014  190.1 
> 
> 
> 

and...

**tblConsuptionsFromB**

> 
> id  meter        date        total  
> 
>  1      1      01/01/2014  164.1  
> 
>  2      1      02/01/2014  133.1  
> 
>  3      1      03/01/2014  136.1  
> 
>  4      1      04/01/2014  125.1  
> 
>  5      1      05/01/2014  190.1  
> 
>  6      1      06/01/2014  103.1  
> 
>  7      1      07/01/2014  164.1  
> 
>  8      1      08/01/2014  133.1  
> 
>  9      1      09/01/2014  136.1  
> 
>  10      1      10/01/2014  125.1  
> 
>  11      1      11/01/2014  190.1 
> 
> 
> 

I need to join these two tables, but if there is an entry for the same day in both table... only take the result from tblConsumptionsFromA.

So the result would be:-

> 
> id source\_id  meter  from       date        total  
> 
>  1     1              1        B    01/01/2014  164.1  
> 
>  2     2              1        B    02/01/2014  133.1  
> 
>  3     1              1        A    03/01/2014  100.1  
> 
>  4     2              1        A    04/01/2014  184.1  
> 
>  5     3              1        A    05/01/2014  134.1  
> 
>  6     4              1        A    06/01/2014  132.4  
> 
>  7     5              1        A    07/01/2014  126.1  
> 
>  8     6              1        A    08/01/2014  190.1  
> 
>  9     9              1        B    09/01/2014  136.1  
> 
>  10    10             1        B    10/01/2014  125.1  
> 
>  11    11             1        B    11/01/2014  190.1 
> 
> 
> 

This is beyond me, so if someone can solve... I will be very impressed.