История изменений

Исправление BaBL, 23.10.12 12:30 (текущая версия) :

CREATE VIEW `last_data` AS 
select 
`date` AS `date`,
`phone` AS `phone`,
`data` AS `data`
from (
     select
          max(date) mdate,
          `phone`
     from `monitoringtable`
      group by `phone`
) md
join monitoringtable mt on `md`.`mdate`=`mt`.`mdate` and `md`.`phone` = `mt`.`phone`

попробуй так

Исходная версия BaBL, 23.10.12 12:27:

CREATE VIEW `last_data` AS 
select 
`date` AS `date`,
`phone` AS `phone`,
`data` AS `data`
from (
     select max(date) mdate
     from `monitoringtable`
      group by `phone`
) md
join monitoringtable mt on `md`.`mdate`=`mt`.`mdate` and `md`.`phone` = `mt`.`phone`

попробуй так