22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE VIEW [NewsVIEW]
AS SELECT [dbo].[OneClass].[oid] as OneClassoid, [dbo].[OneClass].[OneClassName], [dbo].[TwoClass].[tid], [dbo].[TwoClass].[TwoClassName], [dbo].[TwoClass].[oid], [dbo].[MyTable].[mid], [dbo].[MyTable].[tid], [dbo].[MyTable].[myTitle]
FROM [dbo].[OneClass], [dbo].[TwoClass], [dbo].[MyTable]
where OneClass.oid=TwoClass.oid and TwoClass.tid=MyTable.tid