FinanceFerret/2.0/sql/qryCbx Accts

About

• Purpose: dataset for drop-down boxes
• History:
  • 2009-08-30 Created for web interface version

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCbx_Accts AS SELECT

 IFNULL(a.ID_Alias,a.ID) AS ID,
 CONCAT_WS(' < ',a.Name,ap.Name) AS Name

FROM Accounts AS a

 LEFT JOIN Accounts AS ap
 ON a.ID_Parent=ap.ID

ORDER BY Name;</mysql> <section end=sql />