我犹豫不决，但为什么你有多个具有完全相同结构的表？


您是否已阅读并理解本教程中的信息？ 数据库规范化和表格结构


你的问题......你可以通过使用Union查询来完成类似的事情。但是，如果（我怀疑）你有设计问题，处理设计问题将大大简化查询你想要看到的内容的任务。


问候，

Scott

I hesitate to ask, but why do you have multiple tables with the exact same structure?

Have you read and understood the information in this tutorial? Database Normalisation and Table Structures

On to your question... You can accomplish something similar to this by using a Union query. However, if (as I suspect) you have a design issue, taking care of the design issue will greatly simplify the task of querying for what you want to see.

Regards,
Scott

我犹豫不决，但为什么你有多个具有完全相同结构的表？ />

您是否已阅读并理解本教程中的信息？ 数据库规范化和表格结构


你的问题......你可以通过使用Union查询来完成类似的事情。但是，如果（我怀疑）你有设计问题，处理设计问题将大大简化查询你想要看到的内容的任务。


问候，

Scott

I hesitate to ask, but why do you have multiple tables with the exact same structure?

Have you read and understood the information in this tutorial? Database Normalisation and Table Structures

On to your question... You can accomplish something similar to this by using a Union query. However, if (as I suspect) you have a design issue, taking care of the design issue will greatly simplify the task of querying for what you want to see.

Regards,
Scott

i有多个具有相同场地的桌子，但它们有轻微的差异关系，但所有都基于相同的场地。

感谢无论如何生病查询联合查询微软办公室谢谢

i have multiple tables with the same feilds but they have slight diff relation ships depending but all are based on the same feilds.
Thanks anyway ill look up union querys on microsft office thanks

i有多个表具有相同的领域，但他们有轻微的差异关系船只取决于但所有都是基于相同的领域。

感谢无论如何生病查询联合查询微软办公室谢谢

i have multiple tables with the same feilds but they have slight diff relation ships depending but all are based on the same feilds.
Thanks anyway ill look up union querys on microsft office thanks

Daniel，


我的回复并非打算送您到另一个网站！如果您对如何规范表格有疑问，请随时向他们询问！


我想你会发现，如果你规范化表格，你就不需要调查联合查询了。一个简单的选择查询将完成这项工作。


如果您想让我了解您的桌子结构，我可以尝试帮助您改变它们。如果是这样，请发布每个表的表名，字段名和数据类型，以及每个字段中包含的数据的简短示例...


问候，

Scott

Daniel,

My reply was not intended to send you to another site! If you have questions about how to normalize your tables, feel free to ask them!

I think you will find that if you normalize the tables, you will not need to investigate union queries. A simple select query will do the job.

If you wish to give me an idea of the structure of your tables, I can try to help you with how to change them. If so, please post the table name, field names and data types for each table, and a brief sample of the data contained in each field...

Regards,
Scott