如何从多个表创建视图?
我必须从 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.
参考:
- 创建视图
相关文章