SQL_VIEW视图错位的处理方式和注意

CREATE VIEW VIEW1
-- =======================
AS
SELECT   L1,L2，A.* 

FROM  L.L1= A.A1

CREATE VIEW VIEW1
-- =======================
AS
SELECT  L3, L1,L2，A.* 

FROM  L.L1= A.A1

CREATE VIEW VIEW2
-- =======================
AS
SELECT   A.*，D.B2

FROM VIEW1 C  LEFT JOIN B D ON  C.L1=D.B1

ALTER VIEW VIEW2
-- =======================
AS
SELECT   A.*，D.B2

FROM VIEW1 C  LEFT JOIN B D ON  C.L1=D.B1