34,593
社区成员
发帖
与我相关
我的任务
分享
-- DROP TABLE TA,TB
CREATE TABLE TA(A1 INT,A2 INT);
CREATE TABLE TB(B1 INT,B2 INT);
INSERT INTO TA VALUES(1,100),(2,200),(3,300),(4,150);
INSERT INTO TB VALUES(3,100);
SELECT A1,A2,ISNULL(B1,0) AS B1,ISNULL(B2,0) AS B2
FROM TA LEFT JOIN TB ON TA.A1=TB.B1