I tried it in Sybase but I continue to get errors.
Here is the code:
select
a.job,
a.start_time,
b.end_time
from (select distinct date,
job,
start_time,
end_time
from v_control_m_jobs_detail
where start_time <> ""
) a, (select distinct date,
job,
start_time,
end_time
from...