title: How to get missing values in sql?
body: <p>I need help.</p>
  
  <p>I have a sql table t2 related to two other tables t1 and t3.</p>
  
  <p>t2 has fields:</p>
  
  <pre><code>idFromt3 idFromt1 Value
  
  1        14        text1
  2        14        text2
  1        44        text1
  2        44        text2
  3        44        text3
  </code></pre>
  
  <p>I'm searching for values, where ifFromt3 is missing. 
  I want to fint in this example, the value ifFromt3 = 3, because of it's not present.</p>
  
  <p>I'm doing it like this example, but it doesn't work correctly.</p>
  
  <pre><code>SELECT t3.idFromt3, t3.idFromt1
  FROM t3 
    INNER JOIN t2 
      ON t3.LanguageMessageCodeID &lt;&gt; t2.idFromt2
  </code></pre>
  
  <p>This are the 3 tables.</p>
  
  <pre><code>CREATE TABLE [dbo].[t3](
      [t3ID] [int] IDENTITY(1,1) NOT NULL,
      [Name] [varchar](50) NOT NULL,
  )
  
  CREATE TABLE [dbo].[t2](
      [t2ID] [int] IDENTITY(1,1) NOT NULL,
      [t3ID] [int] NOT NULL,
      [t1ID] [int] NOT NULL,
  )
  
  
  CREATE TABLE [dbo].[t1](
      [t1ID] [int] IDENTITY(1,1) NOT NULL,
      [Name] [varchar](50) NOT NULL,
  )
  </code></pre>
  
  <p><strong>UPDATE:</strong> </p>
  
  <p>Tables with data:
  <a href="http://www.2shared.com/photo/40yY6FC-/Untitled.html" rel="nofollow">http://www.2shared.com/photo/40yY6FC-/Untitled.html</a></p>
  
  <p>And I need a query, that returns all missing combinations in table LangugageMessageCodes.</p>
  
  <p>In this case:</p>
  
  <pre><code>LanguageMessageCodeID  LanguageID
  3                      14
  1                      47
  2                      47
  3                      47
  </code></pre>
  
  <p>please. help.</p>
  
  <p>regards.</p>