mysql 建立视图
发布网友
共2个回答
热心网友
create or replace view v_name
as
select t1.*,t2.*,t3.*
from A表 t1, B表 t2, C表 t3
where t1.a=t2.b and t2.b1=t3.c
热心网友
CREATE VIEW 你的视图名字
as
select *
from A JOIN B ON A.a=B.b
join C ON C.c=B.b1
