来自「JAVA下的SQL_System的建立」· 代码 · 共 7 行

CREATE VIEW chanpin_company_view
AS
SELECT company.manager,chanpin.leibie
FROM company,chanpin
WHERE company.id = chanpin.qiyeid
GROUP BY company.manage,chanpin.leibie