Skip to content
Advertisement

SQL | Display all rows where date is not current month

I have two tables
In one table there are my employees and when they changed the Department
In the second table there is my current date

Employee Table

Table with current Date

Now I want to only see all Employee that have no ‘MonthWhenJoined’ equal to the current Month.
So the Result would be something like this

I know it can not be that hard, but I cant figure it out …
Thank you for your help!

Advertisement

Answer

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement