Mysql学习之连接查询

学习峰哥java教程自学笔记：

http://www.java1234.com/javaxuexiluxiantu.html

链接查询：

1、内连接查询

2、外连接查询：

左连接查询，

右连接查询，

两张表结构如下：

t_book:

t_booktype:

SELECT * FROM t_book,t_booktype;

SELECT * FROM t_book,t_booktype WHERE t_book.bookTypeId=t_booktype.id;

SELECT bookName,author,bookTypeName FROM t_book,t_booktype WHERE t_book.bookTypeId=t_booktype.id;

SELECT tb.bookName,tb.author,tby.bookTypeName FROM t_book tb ,t_booktype tby WHERE tb.bookTypeId=tby.id;

SELECT * FROM t_book  LEFT JOIN t_booktype ON t_book.bookTypeId=t_booktype.id;

SELECT tb.bookName,tb.author,tby.bookTypeName FROM t_book tb  LEFT JOIN t_booktype tby ON tb.bookTypeId=tby.id;

SELECT * FROM t_book  RIGHT JOIN t_booktype ON t_book.bookTypeId=t_booktype.id;

SELECT tb.bookName,tb.author,tby.bookTypeName FROM t_book tb  RIGHT JOIN t_booktype tby ON tb.bookTypeId=tby.id;

SELECT tb.bookName,tb.price,tb.author,tby.bookTypeName FROM t_book tb ,t_booktype tby WHERE tb.bookTypeId=tby.id AND tb.price>70;