i have a table table_1 that looks like this
example for table_1:
id name age
1 Bruno 10
2 Benno 11
3 Otto 11
4 Heinrich 12
5 Wolf 10
then i have an other table_2 that looks like this
id exclude_age
1 11
2 10
now i need a query that returns:
table_1.id table_1.name table_1.age
4 Heinrich 12
that means all the lines of table_1 where age is not listed in table_2.exclude_age
i have no idea how this could work, please help, cu schmitty