MYSQL查询选择两个表

Question

我在从两个不同的表中选择数据时遇到问题。参见示例

TABLE1
UserID | Name     | Description
myID01 | myname   | mydescription
myID02 | myname2  | mydescription2
myID03 | myname3  | mydescription3

TABLE2
ID | UserID  | Picture        | Pic_Description
1  | myID01  | mypicture.jpg  | This is my picture

输出必须是显示TABLE1中的所有记录，并仅选择TABLE1到TABLE2中匹配的UserID来显示图片。

正确的 MYSQL 语句必须是什么才能显示我的预期输出？谢谢。

Answer 1

您可以使用 join连接多个表。

select t1.UserID as userid, t1.Name as name, t1.Description as description, t2.picture as picture
from table1 as t1
join table2 as t2
on t1.UserID = t2.UserID