title: Update Trigger with inner join construction
body: <p>i'm not sure is it all correct
  i'm wanreding about if construcion and inner join in where</p>
  
  <pre><code>USE x;
  GO
  IF EXISTS (SELECT typ1
      FROM db.y
      WHERE typ1 ='wartosc' and typ2 = 'wartosc')
  
  DROP TRIGGER triggername;
  GO
  CREATE TRIGGER triggername
  ON [db.jakiasbaza][y.typ]
  AFTER UPDATE
  AS
  declare @zmienna1   
  declare @zmienna2 varchar(20)
  IF (UPDATE (zmienna1))
      SET zmienna1= 'cos1'
  ELSEIF
      SET zmienna1= 'cos2'
  END IF;
  BEGIN
  UPDATE x.typ1
  SET @zmienna1 = 'jakaswartosc'
  WHERE x INNER JOIN y
      ON x.typ1 = y.typ1
      WHERE (x.typ1 = 'wartosc'and x.typ2 = 'wartosc' 
  END;
  GO
  </code></pre>
  
  <p>Thx</p>