问题描述 SQL语句查询问题,求高手指教,急急急 有两个表 b1: name id zhangsan 111 b2: username no lisi 222 一条查询语句,需要查询出的结果是: mc bm zhangsan 111 lisi 222 解决方案 select b1.name as mc, b1.id as bm, b2.username as mc, b2.no as bm from b1,b2 解决方案二: if object_id('Tempdb..#msglist') is