这种样式的SQL怎么写？

有一组确定的值‘aaa’，‘bbb’，‘ccc’，‘ddd’
我想判断他不在另一张表(table)的一列(Filed)里面，如何用一条SQL语句搞定，
之前很傻的写成:
select (‘aaa’，‘bbb’，‘ccc’，‘ddd') not in select Filed from table

---

SQL code:
select count(1from [table] where filed not in('aaa’，‘bbb’，‘ccc’，‘ddd') ?
) 

---

SQL code:

select count(1) from [table] where filed not in('aaa’，‘bbb’，‘ccc’，‘ddd') ?

---

學習

---

怎么样的结果，贴出来

---

SQL code:
select code
from
(
select 'aaa' as code
union all select 'bbb'
union all select 'ccc'
union all select 'ddd'
) t
where code not in (select Filed from table )

---

SQL code:

Create table table1
(
Filed varchar(8000)
)
insert into table1 values ('aaa')
insert into table1 values ('bbb')
insert into table1 values ('ccc')
insert into table1 values ('ddd')
insert into table1 values ('eee')
insert into table1 values ('fff')

select Filed from table1