左连接查询的关键字为:LEFT JOIN + ON
这里是一条左连接的查询语句
select * from SXS_BOOK_INFO a left join SXS_TEST_BOOK b on a.book_name = b.book_name
查询之后的效果:
上述查询是查询两个表书名(字段名:book_name)相同的左连接查询,于是我们用where条件查询得到更精细的结果:
select * from SXS_BOOK_INFO a left join SXS_TEST_BOOK b on a.book_name = b.book_name where a.book_name = '从你的全世界路过'