<div>
or you do a LEFT JOIN:<br />
<br />

<pre><code id="code-20-41456690-1">select *
from Passes1 as P2015
left join Passes as P2016
on P2016.Year = '2016'
and P2016.THID = P2015.THID
where P2015.Year = '2015'
and P2016.THID is null</code></pre>
</div>


or you do a LEFT JOIN:



select *
from Passes1 as P2015
left join Passes as P2016
on P2016.Year = '2016'
and P2016.THID = P2015.THID
where P2015.Year = '2015'
and P2016.THID is null

<div>
...more likely than a Year column you would have an orderdate column and would pick MAX(YEAR(orderdate)) = 2015<br />
<br />
Bye, Olaf.
</div>


...more likely than a Year column you would have an orderdate column and would pick MAX(YEAR(orderdate)) = 2015

Bye, Olaf.

<div>
<div class="content wysiwyg-content">
I have &nbsp;a table called Passes1 that shows every ticket sale we have ever made.<br />
I want to run a query on customers that bought a ticket in 2015 but have not bought yet in 2016<br />
<br />
I have this query - <br />
SELECT * FROM Passes1 as pa WHERE NOT EXISTS (Select * from Passes1 as pa1 WHERE pa.THID=pa1.THID AND pa1.Year = '2016') AND Year ='2015'<br />
<br />
Where am I off?
</div>
</div>


I have  a table called Passes1 that shows every ticket sale we have ever made.
I want to run a query on customers that bought a ticket in 2015 but have not bought yet in 2016

I have this query - 
SELECT * FROM Passes1 as pa WHERE NOT EXISTS (Select * from Passes1 as pa1 WHERE pa.THID=pa1.THID AND pa1.Year = '2016') AND Year ='2015'

Where am I off?

Find customers who ordered in 2015 but not 2016

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.