DROP TABLE IF EXISTS `v_abook`;
DROP VIEW IF EXISTS `v_abook`;

CREATE OR REPLACE VIEW `_mydb_abook`.`v_abook` AS 
SELECT m_abook.*, m_category.c_categoryName, m_category.c_categoryDisplayOrder
FROM m_abook
LEFT OUTER JOIN m_category ON m_abook.id_category = m_category.id_category
WHERE m_abook.c_delete = 0;
