mysql语句改成oracle语句

select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt
from xj_inf x left join site1 s on x.siteName = s.site_id
group by x.id ,x.siteName ,s.site_name , x.flg, x.product


select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt
from xj_inf x left join site1 s on x.siteName = s.site_id group by siteName,pt,flg


select x.id as id,x.siteName as siteId,s.site_name as siteName,x.flg as flg ,x.product as pt
from xj_inf x , site1 s where x.siteName = s.site_id group by siteName,pt,flg