Compare Table With Query

Question

Hello I have a Table with costumers whis have to pay every mounth a rent; the inf. are stored stored in table Rent. Does anybody know if is posible to write an Sql statement that returns costumers that haven't payed the rent for a selected Mounth?

Andrzej Wegierski · Answer

SELECT * FROM costumers WHERE costumer_id NOT IN(SELECT costumer_id FROM rent WHERE payed_month=?)