在一个查询中从两个不同的表中获取数据 [英] Fetch data from two different tables in one query

问题描述

在我的网络服务器上有一个包含以下两个表的数据库:

On my webserver there is a database with following two tables:

tbl_Friend                                    tbl_Colleague

| id | Name | First name | Place |            | id | Name | First name | Place | 
----------------------------------            ----------------------------------
|  1 | XXXX | XXXXXXXXXX |   1   |            |  1 | AAAA | AAAAAAAAAA |   1   |
|  2 | YYYY | YYYYYYYYYY |   2   |            |  2 | BBBB | BBBBBBBBBB |   3   |
|  3 | ZZZZ | ZZZZZZZZZZ |   1   |            |  3 | CCCC | CCCCCCCCCC |   4   |

现在我想从 tbl_Friend 和 tbl_Colleague 中获取住在 place 1 的所有人员.为此，我必须从两个表中获取数据，这是我的问题:如何仅在一个查询中从两个不同的表中获取数据?我的结果应该是这样的:

Now I want to fetch all Persons from tbl_Friend and tbl_Colleague who live in place 1. For that I have to the data from both tables and here is my problem: How can I fetch data from two different tables in only one query? My result should look like this:

| id | Name | First name | Place |
----------------------------------
|  1 | XXXX | XXXXXXXXXX |   1   |
|  1 | AAAA | AAAAAAAAAA |   1   |
|  3 | ZZZZ | ZZZZZZZZZZ |   1   |

我可以使用FROM tbl_Friend 之类的东西吗?tbl_Colleague 还是别的什么?或者我必须为此使用 Join 吗?

Can I use something like FROM tbl_Friend | tbl_Colleague or something else? Or do I have to use a Join for this?

推荐答案

试试这个:

SELECT id, Name, First name, Place FROM tbl_Friend
  WHERE Place= 1
UNION ALL
SELECT id, Name, First name, Place FROM tbl_Colleague
  WHERE Place= 1

这篇关于在一个查询中从两个不同的表中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！