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