View in MySQL

In joomla!, the view should follow the same naming convention as table.

CREATE VIEW jos_bl_arrangement
AS SELECT 
MONTH( m.m_date ) AS mon,
DATE_FORMAT( m.m_date , '%d/%m/%Y') AS date,  
DAYOFWEEK( m.m_date) AS dayweek,
m.team2_id, m.team1_id, m.score1, m.score2, m.m_time, m.m_location, m.m_remark, 
t1.t_name AS home, t2.t_name AS away 
FROM jos_bl_match AS m, jos_bl_teams AS t1, jos_bl_teams AS t2 
WHERE t1.id = m.team1_id AND t2.id = m.team2_id

REFS:

MySQL Official Online Doc: 12.1.12. CREATE VIEW Syntax

MySQL Views

第22章：視圖