Loading

Compare Table With Query

rencels

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

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