有两个表
表1:basicinfo
字段 tb_user school truename note
user1 school1 name1 无
user2 school2 name2 有
user3 school3 name3 无
表2: regisuser
username tpye regisdate password
user1 1 2010 123
user2 0 2012 qwe
user3 1 2006 asd
user4 1 2004 fsd
怎么从两表中查询并输出
username truename type regisdate 用户所对应的信息。
user1 name1 1 2010
user2 name1 0 2012
user3 name1 1 2006
表1:basicinfo
字段 tb_user school truename note
user1 school1 name1 无
user2 school2 name2 有
user3 school3 name3 无
表2: regisuser
username tpye regisdate password
user1 1 2010 123
user2 0 2012 qwe
user3 1 2006 asd
user4 1 2004 fsd
怎么从两表中查询并输出
username truename type regisdate 用户所对应的信息。
user1 name1 1 2010
user2 name1 0 2012
user3 name1 1 2006
select b.tb_user, b.truename, r.type, r.regisdate from basicinfo AS b left join regisuser AS r ON b.tb_user=r.username