I need to make report from one table having two dates column

user_19591797 0
Viewed 36

i have two credit bureau we are using 1 for applicant and another for co-applicant , we are giving different customer ID to each, each record captured there own date so i want to display customer ID and date from both bureau which are available in one table column1 and column2 i want to show both details like below

enter image description here

enter image description here

mysql
2 Answers
select t.cid,t.col1 from t where col1 is not null
union all
select t.cid,t.col2 from t where col2 is not null;
user_61524000 
select id, 
case when col1 is not null then col1 else col2 end,
col1 is not null as 'just_check' 
from t
user_167020580
Related