SQL 关联表作为条件查寻

有两张表 T1, T2

T1:
id, name, T2id ，discription

T2:
id, subName

其中 T1的 T2id 与T2的 id 对应

想以T1的 name 和 T2的 subName 为 条件 查寻T1的 discripton.
请高手指点如何写 where 条件语句

---

SQL code:
select discripton from t1,t2
where t1.id=t2.id and t1.name='值' and t2.subname='值'

---

SQL code:
SELECT *
from T1
INNER JOIN T2 ON T1.T2ID=T2.ID
AND T1.[NAME]='.....' AND T2.SUBNAME='.....'

---

select *
from t1 a ,t2 b
where a.t2id = b.id and (name like '' or subname like '')

---

SQL code:
select t1.id, t1.name, t1.t2id, t1.discription
from t1 rigth join t2 on t1.name=t2.name;

---

SQL code:
select T1.discripton from
(
select * from T1 where name='Name的值'
) T
join
(
select * from T2 where subname='对应的值'
) T2
on T1.T2id=T2.id

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlight