从query1和query2中选择查询

我要猜一下，你想要的是两个输入中的每一个来自 的所有记录查询并且两个查询中的 ID之间没有关系。如果猜测是正确的，那么你需要的是一个UNION查询 。这样的事情： SELECT ID，Prefix，Surname，InwardDate as DDate FROM Query1 UNION SELECT ID，Prefix，Surname，OutwardDate as DDate 来自Query2 看看这是否更接近你的需要。 - Randy Harris tech at promail dot com 我很确定我知道一切我记得。I''m going to make a guess, that what you want is all of the records fromeach of the two input queries and that there is no relation between theIDs in the two queries. If that guess is correct, then what you need isa UNION query. Something like this:SELECT ID, Prefix, Surname, InwardDate as DDateFROM Query1UNIONSELECT ID, Prefix, Surname, OutwardDate as DDateFROM Query2See if this is any closer to what you need.--Randy Harristech at promail dot comI''m pretty sure I know everything that I can remember. 这篇关于从query1和query2中选择查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！