有A,B,C三个表,A(id,pid,tid,a,b) B(pid,c,d) C(tid,e,f)
已知A表字段id='5',想求出a,b,c,d,e,f这几个列,SQL语句怎么写,A.pid=B.pid,A.tid=C.tid。
即求出id='5'的pid,tid,再根据pid、tid求出B的c、d;再求出C的e、f
已知A表字段id='5',想求出a,b,c,d,e,f这几个列,SQL语句怎么写,A.pid=B.pid,A.tid=C.tid。
即求出id='5'的pid,tid,再根据pid、tid求出B的c、d;再求出C的e、f
FROM A,B,C
WHERE A.id=5
AND A.pid=B.pid AND A.tid=C.tid
from a join b on a.pid = b.pid
join c on a.tid = c.tid
where a.id = '5'
from A,B,C
where A.pid=B.pid and A.tid=C.tid and A.id='5'
select A.a,A.b,B.c,B.d,C.e,C.f from A
Inner Join B On A.pid=B.pid
Inner Join C On A.tid=C.tid
where A.id='5'
FROM A,B,C
WHERE A.pid=B.pid and A.tid=C.tid and A.id='5'