Ansi Join syntax

[grenni999]

Hi!

Also ungetestet könnte es so aussehen:

Code:

SELECT *
FROM 
  T1
  INNER JOIN T2 ON(T1.key=T2.Key)
  RIGHT JOIN T3 ON(T1.key=T3.Key),
  T3
  RIGHT JOIN T4 ON(T3.Key=T4.Key)
WHERE 
  T1.Wert like 'Copper%'

Code:

SELECT *
FROM
  T1 INNER JOIN T2 ON (T1.Key=T2.Mykey)
 WHERE
   T2.Wert = 0