一、有两张表a表和b表两张表的结构和数据都相同
id | name |
1 | a |
2 | b |
b表结构一样
求下列查询语句的结果
1、select * from a left join b on a.id = b.id where a.id = 1
2、select * from a left join b on a.id = b.id and a.id = 1
3、select * from a left join b on a.id = b.id
4、select * from a b
5、select * from a b where a.id = b.id
二、请说一下阻塞和死锁的区别