select cout.ci_id,cout.out_id,cin.in_id,cout.out_datetime from t_ci_in cin,t_ci_out cout where cin.out_id(+)=cout.out_id