怎么写这样的sql删除语句???

hug110

两个表,有关联字段YGID,想删除表1中有,而表2中没有的记录,这样的SQL语句怎么写啊?
下面是用ACCESS生成的删除查询,运行不对.
DELETE *
FROM yg_GZLL LEFT JOIN yg_YGMC ON yg_GZLL.YGID = yg_YGMC.YGID
WHERE (((yg_YGMC.YGID) Is Null))

谢谢!!!!!!!!!!!!

fzwzf

关注中