title: SQL SERVER add Check constraint for 2 Colmuns two different tables
body: <p>Hello I want to add a check constraint for a table but I want to compare a two columns from different tables</p>
  
  <pre><code>ALTER TABLE Installation 
  ADD Constraint chk_1 check (DateInstallation &lt; dateachat)
  </code></pre>
  
  <p>DateInstallation is a column for the table Installation and dateachat is from  another table named Support, So how to do that knownig that the code give me an error and thank's </p>