程序代码:
Create TABLE A (userid CHAR(6),pcharge numeric(9,2),createtime datetime)
INSERT INTO A VALUES('000001',10.21,'2001-01-01 12:00')
INSERT INTO A VALUES('000001',10.21,'2001-06-15 08:01')
INSERT INTO A VALUES('000002',10.21,'2011-07-17 05:00')
INSERT INTO A VALUES('000003',10.21,'2021-01-27 03:00')
INSERT INTO A VALUES('000001',10.21,'2002-03-13 02:00')
INSERT INTO A VALUES('000004',10.21,'2008-05-05 16:00')
INSERT INTO A VALUES('000005',10.21,'2009-03-04 17:00')
INSERT INTO A VALUES('000006',10.21,'2017-05-08 14:00')
INSERT INTO A VALUES('000003',10.21,'2023-09-03 13:00')
INSERT INTO A VALUES('000002',10.21,'2020-08-06 18:00')
INSERT INTO A VALUES('000001',10.21,'2001-06-15 08:02')
INSERT INTO A VALUES('000002',10.21,'2000-05-09 04:00')
INSERT INTO A VALUES('000001',10.21,'2002-03-06 17:00')
Create TABLE B (userid CHAR(6),pwprtype char(5),)
INSERT INTO B VALUES('000001','DJ1')
INSERT INTO B VALUES('000002','DJ5')
INSERT INTO B VALUES('000003','DJ1')
INSERT INTO B VALUES('000004','DJ2')
INSERT INTO B VALUES('000005','DJ5')
INSERT INTO B VALUES('000006','DJ1')
INSERT INTO B VALUES('000007','DJ2')
INSERT INTO B VALUES('000008','DJ5')
INSERT INTO B VALUES('000009','DJ5')
如何查表A中不包含的表B的userid呢?我不知道我说明白了没
,就是怎么查出来000007,000008,000009