例如有两个表分别为 book(书籍) 与 publisher(出版社):如果想将book表中的publisher_id与publisher表中的id绑定起来,就需要外键:
create table publisher(//创建table publisher
id char(36) primary key,
name varchar(30) not null,
address varchar(120)
)
create table book(//创建table book
id char(36) primary key,
name varchar(30) not null,
publisher_id char(36),
price decimal(5,2),
author varchar(20),
image_name varchar(41),
foreign key(publisher_id) references publisher(id)//为publisher_id添加外键
)
那么如何实现多表查询呢?
这是多表查询中的一个sql语句。
String sql="select b.id,b.name,b.price,b.image_name,b.author,b.publisher_id,p.name publisher_name " + " from book b" + " left join publisher p on b.publisher_id = p.id "+" where b.id='"+id+"'";