SQL Tutorial neue Schreibweise ?!

[Davidlocke13]

Meine so was !

Alt:

Code:

SELECT c.*,m.*
FROM Mitarbeiter m, cities c
WHERE 1=1
 and m.ort = c.full_name_nd(+)
ORDER BY Name

Neu:

Code:

SELECT c.*,m.*
FROM Mitarbeiter m
left join cities c
  on m.ort = c.full_name_nd and c.cc_fips = 'GM'
WHERE 1=1
ORDER BY Name