how to query for all members didn't pay Subscription fees

Question

 hi all .

I have to tables in sql server :

MembersTable 

NoMem	NameMem	PhoneMem	AddressMem

 

FeesTable

NoMem	FeesDate	Amount

 

how to query for all members didn't pay Subscription fees ,

by where FeesDate or anther way in c# code.

please can anyone help me.

thanks