如何进行选择查询保存内容 [英] how to make select query holding it contents

问题描述

大家好，我在Access 2007中有一个数据库，但它记录在2002 - 2003年，我创建了大约5个选择加入表，其中一个，保持记录但其他人没有，我在寻找问题所在如果我没有得到这个，那些不保存记录的记录与保存记录的记录之间的区别在于保存记录的记录与另一个表中的一个字段相关，其中每个记录中的其他表中的其他一个来自其他桌子的多个项目..



请帮助我知道我可以做些什么来让那些精选查询保存他们的记录。



SHOUTING删除 - OriginalGriff [/ edit]

Hello guys, I have a database in access 2007, but it is recorded in 2002 - 2003, I created around 5 selected to join table together, one among them, hold records but others no, I was looking where the problem might be I did not get that, the difference between those that don't hold records and the one which hold records is that which hold records has one field related to it from another table where others in each one of the selected query in they combination has more than one items from others table..

Please help know what I can do to make those select query holds their records too.

[edit]SHOUTING removed - OriginalGriff[/edit]

推荐答案

永远？如果你只使用SQL，那么你不会把它们写回到表中，使用这样的插入查询



http://www.w3schools.com/sql /sql_insert_into_select.asp



否则你会编写代码来将结果读成你以后的任何格式......

Forever? So would you not write them back to a table if you are using SQL only, using an insert query like this

http://www.w3schools.com/sql/sql_insert_into_select.asp

Otherwise you would write code to read the results into whatever format you are after...

这篇关于如何进行选择查询保存内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！