Hi Lynn

Thank you for your reply also... I'm not attending a school, I'm teaching myself about databases by solving various questions that i'm picking up on the internet... I'm from...

Hi Seraj

Thanks for the quick reply... That worked perfectly... Much appreciated

Thank you

Thankyou very much for your help Lowell, it's working perfect now...

select *

from Customers

LEFT OUTER JOIN Meters ON Customers.idCustomers = Meters.Customers_idCustomers

LEFT OUTER JOIN MeterReadings ON Meters.idMeters = MeterReadings.Meters_idMeters

LEFT OUTER JOIN Invoice...

Hi Lowell

Thanks for the reply.

I've tried that query and got the following error:

Error Code: 1054. Unknown column 'Meters.idCustomers' in 'on clause'

select *

from Customers

LEFT OUTER JOIN Meters ON Customers.idCustomers = Meters.idCustomers

LEFT...