如何从多个表创建视图? [英] How can I create a view from more than one table?

问题描述

我必须从 MS SQL Server 数据库中的多个表创建视图，但我无法获得相同的正确语法.

I have to create a view from more than one table in an MS SQL Server database, but I am not able to get the correct syntax for the same.

推荐答案

您必须提供有关如何从多个表中返回数据的更多信息.通常您使用 JOIN:

You'll have to provide more information about how you are looking to return data from more than one table. Typically you use JOINs:

CREATE VIEW your_view_vw AS
   SELECT *
     FROM TABLE_A a
     JOIN TABLE_B b ON b.pk = a.fk

...其中 fk 代表外键"，而 pk 代表主键"——假设这些约束已经到位.也许您需要改用交叉连接?这是一个 JOIN 的出色视觉表示.

...where fk stands for "Foreign Key", and pk stands for "Primary Key" - assuming these constraints are in place. Maybe you need to use a Cross join instead? Here's a great visual representation of JOINs visually.

参考:

• 创建视图

这篇关于如何从多个表创建视图?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！