Question

能不能在一条SQL语句里，查询两张表

Answer 1

select
    A.username
from
    user1 A
    ,user2 B
where
    A.username = 'zhangsan' and
    A.username = B.username