Oracle translation to sybase sql

[martyc71]

Anyone out there know if the following code can be accomplish in Sybase ?

Oracle:

select
aa.field1,
bb.field2
from
(select keyfield, field1 from table1) aa,
(select keyfield, field2 from table2) bb
where aa.keyfield = bb.keyfield

Thanks

 

[nagornyi]

This code is ANSI SQL compatible, should be OK on Sybase.

 

[martyc71]

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 v_control_m_jobs_detail
where end_time <> ""
) b
where a.job = b.job

I guess I could accomplish what I want by creating #temp tables.