SQL SELECT FROM Two
TABLE1

ID    |     DATE  
 a    |   10-06-2012    |   
 b    |   07-07-2012    |   
 c    |   10-06-2012    |   
 
TABLE2

ID    |  COST  |  
 a    |   3    |  
 b    |   4    |  
 c    |   4    | 

I have two Tables and I would like to search the DATE e.g. 10-06-2012 and return the total COST for that DATE being 7.

ID is common in both tables.
SQL SELECT FROM Two
===

TABLE1

ID    |     DATE  
 a    |   10-06-2012    |   
 b    |   07-07-2012    |   
 c    |   10-06-2012    |   
 
TABLE2

ID    |  COST  |  
 a    |   3    |  
 b    |   4    |  
 c    |   4    | 

I have two Tables and I would like to search the DATE e.g. 10-06-2012 and return the total COST for that DATE being 7.

ID is common in both tables.