My join query is below
from dbo.maintenanceOrders o inner join tenantRentals tr on tr.primaryKey = o.rentalUnitID
inner join tenants T on t.primaryKey = tr.tenantID
Inner JOIN CalenderEvent CE on CE.tenantID = T.primaryKey
I do have maintanceorders table contain rentalUnitID and scheduledate.
tenantRentals contrain rentalunitID,and primarykey
Tenant table contain primarykey
and calcnder event table also contain TenantID ,Date.
I am trying to join this tbale but at the end it is giving me 0 result if I eliminate calnder event table than I am getting schedule date perfect but with calnder event I am not able to get schedule_date and Date.
Please help me out with this.I already wasted so much time.