Author: danydb Date: 2012-01-07 23:44:15 +0100 (Sat, 07 Jan 2012) New Revision: 267
Added: trunk/coprop/sql/create_view_summary.sql Removed: trunk/coprop/sql/create_view_summary.sql.sql Log: fix name Copied: trunk/coprop/sql/create_view_summary.sql (from rev 266, trunk/coprop/sql/create_view_summary.sql.sql) =================================================================== --- trunk/coprop/sql/create_view_summary.sql (rev 0) +++ trunk/coprop/sql/create_view_summary.sql 2012-01-07 22:44:15 UTC (rev 267) @@ -0,0 +1,11 @@ +CREATE OR REPLACE VIEW coprop.summary AS + SELECT a.f_id AS lot_id, m.ad_value AS building_id, c.ad_value AS coprop_id + FROM fiche_detail a + JOIN fiche f1 ON f1.f_id = a.f_id + JOIN ( SELECT fd1.f_id, fd1.ad_value + FROM fiche_detail fd1 + WHERE fd1.ad_id = 70) m ON m.f_id = a.f_id + JOIN ( SELECT fd1.f_id, fd1.ad_value + FROM fiche_detail fd1 + WHERE fd1.ad_id = 71) c ON c.f_id = a.f_id + WHERE f1.fd_id = 8 AND a.ad_id = 1; \ No newline at end of file Deleted: trunk/coprop/sql/create_view_summary.sql.sql =================================================================== --- trunk/coprop/sql/create_view_summary.sql.sql 2012-01-07 22:42:05 UTC (rev 266) +++ trunk/coprop/sql/create_view_summary.sql.sql 2012-01-07 22:44:15 UTC (rev 267) @@ -1,11 +0,0 @@ -CREATE OR REPLACE VIEW coprop.summary AS - SELECT a.f_id AS lot_id, m.ad_value AS building_id, c.ad_value AS coprop_id - FROM fiche_detail a - JOIN fiche f1 ON f1.f_id = a.f_id - JOIN ( SELECT fd1.f_id, fd1.ad_value - FROM fiche_detail fd1 - WHERE fd1.ad_id = 70) m ON m.f_id = a.f_id - JOIN ( SELECT fd1.f_id, fd1.ad_value - FROM fiche_detail fd1 - WHERE fd1.ad_id = 71) c ON c.f_id = a.f_id - WHERE f1.fd_id = 8 AND a.ad_id = 1; \ No newline at end of file _______________________________________________ Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
