Found completed task ID: 99 === TEST 1: Direct SELECT === Query: SELECT * FROM tblmaintenance_tasks WHERE ID='99' Success - Got task TaskCost: 20.00 HoursWorked: 0.00 TotalAmount: 20.00 PoolID: 9 === TEST 2: LEFT JOIN === Query: SELECT t.*, p.ChargingMethod, p.ChargingAmount FROM tblmaintenance_tasks t LEFT JOIN tblpools p ON t.PoolID = p.ID WHERE t.ID='99' Success - Got task ChargingMethod: Per Visit ChargingAmount: 20.00 === TEST 3: Direct Pool Query === Query: SELECT * FROM tblpools WHERE ID='9' Success - Got pool PoolName: Paradissia Luxe Villa ChargingMethod: Per Visit ChargingAmount: 20.00