select
*
from
a,b,c,d,e
where
a.字段1 = b.字段1
and
b.字段2 = c.字段2
and
c.字段3 = d.字段3
and
d.字段4 = e.字段4
and
e.主键值 = ...
*
from
a,b,c,d,e
where
a.字段1 = b.字段1
and
b.字段2 = c.字段2
and
c.字段3 = d.字段3
and
d.字段4 = e.字段4
and
e.主键值 = ...
a.主键值,
b.主键值,
c.主键值,
d.主键值
from
a,b,c,d,e
where
a.字段1 = b.字段1
and
b.字段2 = c.字段2
and
c.字段3 = d.字段3
and
d.字段4 = e.字段4
and
e.主键值 = ...
Select A.主键1,B.主键2,C.主键3,D,主键4
from A
Inner Join B On A.字段1=B1.字段1
Inner Join C On A.字段2=B1.字段2
Inner Join D On A.字段3=B1.字段3
Inner Join E On A.字段4=B1.字段4
Where E.主键5='查询的值'
Select A.主键1,B.主键2,C.主键3,D,主键4
from A
Inner Join B On A.字段1=B.字段1
Inner Join C On B.字段2=C.字段2
Inner Join D On C.字段3=D.字段3
Inner Join E On D.字段4=E.字段4
Where E.主键5='查询的值'
a.主键字段,
b.主键字段,
c.主键字段,
d.主键字段
from
a inner join b on
a.相等字段 = b.相等字段
inner join c on
b.相等字段 = c.相等字段
inner join d on
c.相等字段 = d.相等字段
inner join e on
d.相等字段 = e.相等字段
where e.主键值 = 'XXX'