Select records from a table where two columns are not present in another table
<p>I have Table1:</p>

<pre><code>Id      Program Price   Age
12345   ABC     10      1
12345   CDE     23      3
12345   FGH     43      2
12346   ABC     5       4
12346   CDE     2       5
12367   CDE     10      6
</code></pre>

<p>and a Table2:</p>

<pre><code>ID      Program BestBefore
12345   ABC     2
12345   FGH     3
12346   ABC     1
</code></pre>

<p>I want to get the following Table,</p>

<pre><code>Id      Program  Price  Age
12345   CDE      10     1
12346   CDE      2      5
12367   CDE      10     6
</code></pre>

<p>I.e get the rows from the first table where the ID+Program is not in second table. I am using MS SQL Server express 2012 and I don't want to add any columns to the original databases. Is it possible to do without creating temporary variables?</p>