ตอนที่ 14 : การสร้าง View Table บน SQL Server Database (SQL Server : View Table)

CREATE VIEW view_name
AS
            // Statement

CREATE VIEW [VIEW_CUSTOMER_INFO]
AS
SELECT     A.CUSTOMER_ID, A.NAME, B.COUNTRY_NAME, A.BUDGET, A.USED, COUNT(C.AUDIT_ID) AS ITEM_AUDIT
FROM         CUSTOMER AS A LEFT OUTER JOIN
                      COUNTRY AS B ON A.COUNTRY_CODE = B.COUNTRY_CODE LEFT OUTER JOIN
                      AUDIT AS C ON A.CUSTOMER_ID = C.CUSTOMER_ID
GROUP BY A.CUSTOMER_ID, A.NAME, B.COUNTRY_NAME, A.BUDGET, A.USED

SELECT * FROM VIEW_CUSTOMER_INFO

SELECT * FROM VIEW_CUSTOMER_INFO WHERE ITEM_AUDIT >= 3