Question

数据库多表内联（3个以上）怎么写？

比如说有一个 titles表，，有一个authors表，和 titleauthor表，
就是pubs库里的那些，， titles 和 authors 都在titleauthor里有外键，
怎么写（最好把on 后面的格式也写下) 谢谢
ps：我学的 mssql

Answer 1

select * from titles inner join titleauthor
on(titles.主键=titleauthor.外键)
inner join authors
on(titleauthor.外键=authors.主键)

Answer 2

举个例子

select *
from titleauthor a inner join titles b on a.A1=b.B1
inner join authors c on a.A2=c.C1

Answer 3

select * from titleauthor ta inner join titles t on ta.tid = t.id inner join authors a on ta.aid = a.id