27,579
社区成员
发帖
与我相关
我的任务
分享
create view v_add AS
select a.Customerid, a.Customername as Customername1 , b. Customername as Customername2
from table1 a, (select table2.Customerido,table1.Customername from table1,table2 where
table1.Customerid = table2.Customerid2) b
where a.Customerid = b.Customerido
create view vv
as
select Customername1=a.Customername ,Customername2=b.Customername
from 客户名称表 a,客户名称表 b,客户订单表 c
where a.Customerido=c.Customerid
and b.Customerid2=c.Customerid
select
*
from
(select a.Customerid,b.Customername from 客户订单表 a,客户名称表 b where a.Customerid=b.Customerid)a
left join
(select a.Customerid,b.Customername from 客户订单表 a,客户名称表 b where a.Customerid2=b.Customerid)b
on
...