create phpmyadmin view

** If you bid now, you start now ** No companies just freelancers. I need a view created in phpmyadmin Before i used to have this. select `bettingdb`.`results`.`race_id` AS `raceid`,`bettingdb`.`races`.`race_number` AS `race_number`,`bettingdb`.`results`.`event` AS `event`,`bettingdb`.`horses`.`horse_name` AS `horse_name`,`bettingdb`.`results`.`position` AS `position`,`bettingdb`.`results`.`distance` AS `dist`,`bettingdb`.`horses`.`horse_fixed_odds` AS `horse_fixed_odds`,`bettingdb`.`data`.`distance` AS `distance`,`bettingdb`.`data`.`handicap` AS `handicap` from (((`bettingdb`.`horses` left join `bettingdb`.`data` on((`bettingdb`.`horses`.`horse_name` = `bettingdb`.`data`.`name`))) left join `bettingdb`.`results` on((`bettingdb`.`horses`.`horse_name` = `bettingdb`.`results`.`horse`))) left join `bettingdb`.`races` on((`bettingdb`.`races`.`race_id` = `bettingdb`.`results`.`race_id`))) where (`bettingdb`.`results`.`race_id` is not null) group by `bettingdb`.`data`.`id` order by `bettingdb`.`data`.`id` desc But now i have a new db structure and need it changed to reflect the new tables