我可以创建一个自定义表，其数据来自多个表，如果是，如何？ [英] Can I create a custom tables with data pulls from multiple tables, if yes, how?

问题描述

大家好



感谢您分享丰富的知识。



我想创建一个表格，我可以从多个表格中编译数据而不知道如何操作。



请分享您可能拥有的任何简单示例。感谢您的帮助！

Hi Guys

Thanks for the shared wealth of knowledge.

I want to create a table where i can compile data from multiple tables and have no idea how to do it.

Please share any simple examples you might have. Thanks for the help!!

推荐答案

您可以根据获取您想要查看的数据的查询在数据库中创建一个视图。

You could create a View in the database based on a query that gets the data you want to see.

你不是在谈论加入吗？表格之间的关系是一对多，多对多？

Aren't you talking about Joins? Which kind of relation between tables are you talking about one to many, many to many?

这篇关于我可以创建一个自定义表，其数据来自多个表，如果是，如何？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！