SQL Server + select行及其子表内容

Question

我的select语句很简单，如下所示：

SELECT 
[NAME], 
[AGE], 
[GENDER], 
SELECT [PHOTOS] FROM [USERPHOTOS] WHERE... --Yes, this is wrong but just want to make my intentions clearer. 
FROM PEOPLE WHERE AGE = '20'

被选中的人可能在另一个表中有多张照片，如何选择这种查询才能同时抓取照片？

Answer 1

使用连接：http://www.w3schools.com/sql/sql_join.asp

SELECT 
[NAME], 
[AGE], 
[GENDER],
[Photo]
From [People]
Inner join [PHOTOS] on People.ID = Photo.OwnerID

WHERE AGE = '20'

我假设photo和people没有相同的列名，以避免列名的歧义。我假设在照片表中有一个外键，它指向一个人。