回答編集履歴
1
t2.date -> t3.date
    
        answer	
    CHANGED
    
    | @@ -60,7 +60,7 @@ | |
| 60 60 | 
             
            select
         | 
| 61 61 | 
             
              t3.value
         | 
| 62 62 | 
             
            , t1.col3
         | 
| 63 | 
            -
            ,  | 
| 63 | 
            +
            , t3.date
         | 
| 64 64 | 
             
            from table1 as t1
         | 
| 65 65 | 
             
                 left join t2 
         | 
| 66 66 | 
             
              on t1.col1 = t2.col1 
         | 
