有些朋友看到這個標題可能會有疑問
我這裡
create view vCustomersA
as
select CustomerID
Address
from dbo
go
create view vCustomersB
as
select * from vCustomersA
go
然後
select * from vCustomersA where CustomerID =
select * from vCustomersB where CustomerID =
[
From:http://tw.wingwit.com/Article/program/SQLServer/201311/22386.html