sql语句，提取不出数据了，大神帮忙看下

Question

select '测试',td.name,count( distinct lg.family_id)                                                                                                                                                                                                                                                                                                                                            
from cs_transaction_log lg                                                                                                                                                                                                                                                                                                                                                                     
left join tranpackage_define td on td.salemodalid=lg.transaction                                                                                                                                                                                                                                                                                                                               
where    lg.charge=1  and book_type=1 and open=0 and to_char(lg.open_date,'yyyy-mm-dd')>='2015-12-01'                                                                                                                                                                                                                                                                                          
and to_char(lg.open_date,'yyyy-mm-dd')<='2015-12-31' and td.name like '%%'                                                                                                                                                                                                                                                                                                            
group by '测试',td.name

Answer 1

这没报错，只是没有数据，说明没有符合你where条件的匹配数据