sql 操作，

SELECT * FROM dbo.tbl_Web_Photos AS pt
LEFT JOIN dbo.tbl_Web_Friends AS fd ON pt.user_email=fd.AddEmail
WHERE fd.Email='[e-mail]'

记录。