急!!求MYSQL三表关联查询方法

2025-03-22 19:10:30
推荐回答(3个)
回答1:

select * from subject a join attachment b on a.tid=b.tid
join message c on b.tid=c.tid

或者

select * from subject a ,attachment b ,message c
where a.tid=b.tid and b.tid=c.tid

回答2:

select *
from A, B, C
where A.tid=B.tid
and B.tid=C.tid

回答3:

用子查处或是连接