mysql view myadmin

DROP TABLE IF EXISTS `v_faq`;
CREATE VIEW `v_faq` AS select `faq_rubrics`.`rubric_id` AS `rubric_id`,`faq_rubrics`.`name` AS `name`,`faq`.`id` AS `id`,`faq`.`ask` AS `ask`,`faq`.`answer` AS `answer` from (`faq_rubrics` left join `faq` on((`faq`.`rubric_id` = `faq_rubrics`.`rubric_id`))) where (`faq`.`rubric_id` is not null);