多表查询的问题

[startexcel]

表A(调拨单表)
....
targetstockid,sourcestockid
....
targetstockid是目标仓库ID
sourcestockid是源仓库ID
表b(仓库说明表)
ID,NAME
现表A中有如下数据
...,targetstockid,sourcestockid....
1 , 2
怎么写SQL语句能达到如下效果
....TARGETSTOCKNAME,SOURCESTOCKNAME.....
城东仓库, 城北仓库

[startexcel]

注:表A的TARGETSTOCKID和SOURCESTOCKID是表B的ID的外键

[daihaidong]

select b.name as ARGETSTOCKNAME , c.name as SOURCESTOCKNAME
from 表A a , 表b b , 表b c
where a.targetstockid = b.id and a.sourcestockid = c.id

[dinya2003]

select
b.name targetstockname,
c.name sourcestockname
from
tablea a,
tableb b,
tableb c
where
a.targetstockid=b.id
and a.sourcestockid=c.id

[zealot_zk]

select t.name TARGETSTOCKNAME,s.name SOURCESTOCKNAME
from table_a d,table_b t,table_b s
where d.targetstockid=t.id and d.sourcestockid=c.id;