J
Joe Cilinceon
I'm trying to find out if a tenant still rents a unit. Now I have 2 tables
one is Tenants with CustNo that ties it to the Leases table. Now a tenant
can have more than one unit and I'm want only those tenants that no longer
rents.
TENANT
CustNo
LEASES
UnitNo
EndDate (will be null if rented or a date if no longer rented)
one is Tenants with CustNo that ties it to the Leases table. Now a tenant
can have more than one unit and I'm want only those tenants that no longer
rents.
TENANT
CustNo
LEASES
UnitNo
EndDate (will be null if rented or a date if no longer rented)