求SQL语句：联合查询
type表
id,typename,englishname
1，新闻，news
2,法规,law
3,服务，service

flashAd表，

id,jsName,
1,news_ad.js
2,law_ad.js

type表的englishName与flashad表的jsName 相对应。

要求：查询出来type表中，在flashad表中没有对应记录的记录。




[解决办法]
select *
from [type]
where englishname not in (select jsName from flashAd)
[解决办法]
select *
from [type] a
where not exists(
select *
from flashAd b
where a.englishname = b.jsName
)

or:

select *
from [type]
where englishname not in (select jsName from flashAd)

or:

select *
from [type]
where englishname <> any (select jsName from flashAd)
[解决办法]
SELECT * FROM type
WHERE EXISTS (SELECT *FROM flashAd WHERE flashAd.jsName=type.englishname)

[解决办法]
SELECT * FROM type
WHERE NOT EXISTS (SELECT *FROM flashAd WHERE flashAd.jsName=type.englishname)
[解决办法]
select t.* from type表 t inner join flashAd表 f on t.jsName <> f.jsName