c# - 通过条目获取条目

Question

我有以下场景:

文章表

id | description | supplierID
_____________________________
1  | Testarticle | 1

供应商表

id | description 
_______________________
1  | Example Industries

比如读一篇文章的时候SELECT * FROM articles WHERE ID=1，我还需要结果中的供应商描述。

实现此目标的合适方法是什么？

Answer 1

select a.id as ArticleID, a.description as ArticleDescription, a.SupplierID,
s.description as SupplierDescription
from articles a
inner join supplier s on a.supplierID = s.supplierID
where a.id = 1