Result!
Jason, you are a genius!
That works a treat (with a minor change to lines 2 and 3)
FROM mainTabel
INNER JOIN childTable1 ON mainTable.FKColumnForChildTable1 = childTable1.ID
INNER JOIN childTable2 ON mainTable.FKColumnForChildTable2 = childTable2.ID
INNER JOIN childTable3 ON mainTable.FKColumnForChildTable3 = childTable3.ID
Thanks