我有两张表,表A。表BA表id int
typeID1 int
typeID2 int
typeID3 int B表id,
TypeID,
TypeName,
A表的typeID1,2,3关联 B表的TypeID, 请问我如何根据公司ID 得到TypeID1,2,3的TypeName
typeID1 int
typeID2 int
typeID3 int B表id,
TypeID,
TypeName,
A表的typeID1,2,3关联 B表的TypeID, 请问我如何根据公司ID 得到TypeID1,2,3的TypeName
b1.TypeName as TypeName1,
b2.TypeName as TypeName2,
b3.TypeName as TypeName3
from ((a inner join b as b1 on a.typeID1=b1.TypeID)
inner join b as b2 on a.typeID2=b2.TypeID)
inner join b as b3 on a.typeID3=b3.TypeID
where a.id=5;
.
[align=center]==== 思想重于技巧 ====
[/align]
.
贴子分数<20:对自已的问题不予重视。
贴子大量未结:对别人的回答不予尊重。
.
SQL 1992
MySQL 5.1 Reference Manual
数据库系统概论PPT.
[align=center]==== 思想重于技巧 ====
[/align]
.
贴子分数<20:对自已的问题不予重视。
贴子大量未结:对别人的回答不予尊重。
.