select name,sex,age,tel from t1 a,t2 b,t3 c where a.uid=b.uid and a.uid=c.uid where a.name='朱泽民'
解决方案 »
- 面向对象之Onclick事件重写问题!
- 如果通过已经获取到的 hProcess 句柄获取该句柄的PID??
- 一個運行的嚴重錯誤。
- 在OpenDialog上如何加一个按钮?
- dll
- 韓國人都是色狼!同意者請進來報個名。
- 我要自杀了!谁来救我!如何将从串口读出的ASCii码流读到RcihEdit中,同时对ASCii码流进行分析,取特定字符串?
- Access2000中的一个字段是Teacher/Student,Table用到该字段就报错!我该怎么办?
- 一个表有很多字段设置成 not null,如何在tabl1.post 之前检测到dbeditx.text <>''?
- activeform资源释放
- 文件拷贝
- ListView的item数量是否有个最大限制?是多少?
From T1 a,T2 b,T3 c
Where a.Uid=b.Uid and a.Uid=c.Uid and Name='朱泽民'
From T1
Left Join T2 On T1.Uid=T2.Uid
Left Join T3 On T1.Uid=T3.Uid
where T1.Name='朱泽民'
FROM T1,T2,T3
WHERE T1.UID=T2.UID AND T1.UID=T3.UID AND T1.NAME='TT1'
From T1
Left Join T2
On T1.Uid=T2.Uid
Left Join T3
On T1.Uid=T3.Uid
where T1.Name='朱泽民'
或:
Select T1.Name,T2.Sex,T2.Age,T3.Tel
From T1,T2,T3
where T1.Uid=T3.Uid and T1.Uid=T3.Uid and T1.Name='朱泽民'
搞定!
From T1,T2,T3
where T1.Uid=T3.Uid and T1.Uid=T3.Uid and T1.Name='朱泽民'
From T1
Left Join T2
On T1.Uid=T2.Uid
Left Join T3
On T1.Uid=T3.Uid
where T1.Name='朱泽民'
或:
Select T1.Name,T2.Sex,T2.Age,T3.Tel
From T1,T2,T3
where T1.Uid=T3.Uid and T1.Uid=T3.Uid and T1.Name='朱泽民'
或者是
Select T1.Name,T2.Sex,T2.Age,T3.Tel
From T1
inner Join T2
On T1.Uid=T2.Uid
inner Join T3
On T1.Uid=T3.Uid
where T1.Name='朱泽民'
From T1 a,T2 b,T3 c
Where a.Uid=b.Uid and a.Uid=c.Uid and Name='朱泽民'
From T1,T2,T3
Where T1.Uid=T2.Uid and T2.Uid=T3.Uid
and T2.ID=T3.ID and T1.Name='朱泽民'