Inner Join Question

[admin]

I have an issue where I am joining a table on a table.

The problem is the table I am joining has more than one row of matching
data.

 

 

SELECT `customer`.`name`, `comments`.`note` FROM customer

INNER JOIN  `comments` ON `customer`.`id` = `comments`.`customer`

WHERE 

`customer`.`join_date` >= "2012-01-01 00:00:00"

ORDER BY `customer`.`join_date`

ASC

 

 

I need to return all the customers and the last note for each customer

But what I get is a list with the repeat of each customer for each note.