CREATE VIEW mydb.view1 AS SELECT * FROM taba a,tabb b WHERE a.name=b.id 或者 CREATE VIEW mydb.view2 AS select * from (SELECT * FROM taba a,tabb b WHERE a.name=b.id) a 另外最好不要用*,把字段都列出来
mysql 多表自连接后的单表左连接如何建立视图
CREATE VIEW mydb.view1 AS
SELECT * FROM taba a,tabb b WHERE a.name=b.id
或者
CREATE VIEW mydb.view2 AS select * from
(SELECT * FROM taba a,tabb b WHERE a.name=b.id) a
另外最好不要用*,把字段都列出来2015-04-07
和写sql语句一样呀，只是外面加个壳子就行了2015-04-07
