Select differentiating records from two tables

Question

I have two tables with a field called Date. I want to select only the dates of Table1 that are diferent from Table2.

In this case, the result would be 4 and 5.

Table1     Table2     Result
Date       Date       Date
1          1          4
2          2          5
3          3
4
5

@Paul - 2 and 3 does not make sense. Do you want records that are in both tables? (then 1, 2, 3 should be the result). Or do you want records that are not in one of the tables? (then 4,5 should be the result). — Jan Rydrych, Mar 11 '17 at 19:53

score 3 · Accepted Answer · answered Mar 11 '17 at 19:50

3

If I understand correctly your question you want to select from Table1 the rows that are not in Table2 as well. Here is how you would do that:

SELECT Date FROM Table1 WHERE Date not in (SELECT Date FROM Table2)

answered Mar 11 '17 at 19:50

Gab

1 Answers1