vb+mssql，AB两表联合查询，结果是合并，A表无数据的用0补。具体结果在下面补充里。

显示全部楼层 · 2011-2-23 16:27:39

A表
sam_name sam_all
cv0015
cf2529
cs6633
cr9111
cj4142
B表
sam_name sam_bad
cf2523
cs6631
想查询出来的结果(sam_all从高到低)
sam_name sam_allsam_bad
cf25293
cv00150
cs66331
cj41420
cr91110

千问 · 2011-2-23 16:27:39

select a.sam_name, a.sam_all, isnull(b.sam_bad,0) as sam_badfrom a left join b on a.sam_name=b.sam_name order by a.sam_all desc