select date_id,date_time,location,obj_type,case when obj_type='lover' then (select lover_name from t_lover where lover_id=t.obj_id) else (select lover_group_name from t_lover_group where lover_group_id=t.obj_id) end as obj_name,make_love_flag,make_love_times,moeny_used,remark from t_lover_date t where to_char(date_time,'yyyy-mm-dd') like='%02-14'
|