SQL语句查询问题,求高手指教，急急急

Question

有两个表
b1：
name id
zhangsan 111

b2: username no
lisi 222

一条查询语句，需要查询出的结果是：
mc bm
zhangsan 111
lisi 222

Answer 1

select b1.name as mc, b1.id as bm, b2.username as mc, b2.no as bm
from b1,b2