Converting MS SQL Server syntax so Oracle SQL can Understand

[danharman]

Hi All,

Can anyone assist with the following MS SQL Server qeury that I need to run on Oracle? I am having trouble converting the syntax for cross join.....

Any help would be appreciated.

Djh


Select f2.flightno, COUNT(f2.flightno) as NumCities
From FLIGHT f2
cross join
(
Select fto ,flightno
From FLIGHT
Where flightno = 'EA31'
) f1
Where f2.flightno <> 'EA31' and f2.fto = f1.fto
Group by f2.flightno
Having COUNT(f2.flightno) =
(select count(flightno) from FLIGHT
where flightno = 'EA31')

 

[danharman]

BTW: thanks bp for the source sql!