SQL 多表查询优化问题

Question

有四个表  1: checks  2: vendors 3: bank 4: stocks

checks 是基础表  其中有三个字段 vendors_id      bank_id      stocks_id

分别与其他三个表对应

 

如果我要取得字段列表为  checks.name    vendors.name   bank.name  sorcks.name

 

这个SQL语句应该怎么写.                               

Answer 1

[code="SQL"]
SELECT
A.name
, B.name
, C.name
, D.name
FROM checks A
INNER JOIN vendors B ON
A.vendors_id = B.vendors_id
INNER JOIN bank C ON
A.bank_id = C.bank_id
INNER JOIN stocks D ON
A.stocks_id = D.stocks_id
[/code]