34,838
社区成员




SELECT A.*,CASE WHEN B.WEIGHT IS NULL THEN '--' ELSE B.WEIGHT END AS B.WEIGHT
FROM A LEFT JOIN B ON A.NAME=B.NAME
SELECT A.*,CASE WHEN B.WEIGHT IS NULL THEN '--' ELSE B.WEIGHT
FROM A LEFT JOIN B ON A.NAME=B.NAME
select a.*,isnull(b.weight,'--') from a left join b on a.name=b.name
SELECT a.*,ISNULL(b.WEIGHT,'--') FROM a
LEFT JOIN b ON a.name=b.name