Duplicate record in a query with LEFT JOIN, how to fix it?

Question

css

Upon request

SELECT CONCAT(maintb.name, ', ', country1.country, ', ', region.region,', ', house.house) 
AS ADDRESS FROM maintb
  LEFT JOIN country1
   ON country1.id = {0}
     LEFT JOIN region
      ON region.id ={1}
        LEFT JOIN house
         ON house.id ={2}

The output of records occurs 6 times instead of once, how can I fix this?

Answer 1

SQL SELECT DISTINCT Statements