怎么能将我的sqlserver查询语句换成Access中的查询语句
SELECT peple.id, peple.p_nid, peple.p_kid, peple.p_or_ID, peple.p_ID AS youxianid,
peple.p_photo AS photo, peple.p_Name AS name, peple.p_byName,
peple.p_Sex AS sex, sexid.rscode AS sexid, sexname.ncl_Name AS sexname,
peple.p_Birthday AS birthday, peple.p_jg AS jg, peple.p_mz AS mz,
peple.p_cjgzsj AS cjgzsj, peple.p_zzmm, zzmmid.rscode, zzmmname.ncl_Name,
peple.p_rdsj, peple.p_sf, sfid.rscode AS shenfenid,
sfname.ncl_Name AS shenfenname, peple.p_xl, peple.p_byyx, peple.p_xgzdw,
peple.p_zbqk, peple.p_jl, peple.p_drsj, peple.p_zzqk, zzid.rscode AS zzqkid,
zzname.ncl_Name AS zzqkname
FROM dbo.p_NClass zzname LEFT OUTER JOIN
dbo.ClassMain zzid ON zzname.ncl_ID = zzid.rscode AND
zzname.ncl_ClassID = '16' RIGHT OUTER JOIN
dbo.p_Personnel peple LEFT OUTER JOIN
dbo.ClassMain sexid ON sexid.gacode = peple.p_Sex AND
sexid.rsziduan = 'P_Sex' AND sexid.gaziduan = 'A0104' INNER JOIN
dbo.p_NClass sexname ON sexid.rscode = sexname.ncl_ID AND
sexname.ncl_ClassID = '6' ON zzid.gacode = peple.p_zzqk AND
zzid.rsziduan = 'p_zzqk' AND zzid.gaziduan = 'A0199' LEFT OUTER JOIN
dbo.ClassMain sfid ON peple.p_sf = sfid.gacode AND sfid.rsziduan = 'p_sf' AND
sfid.gaziduan = 'A0151' LEFT OUTER JOIN
dbo.p_NClass sfname ON sfid.rscode = sfname.ncl_ID AND
sfname.ncl_ClassID = '8' LEFT OUTER JOIN
dbo.ClassMain zzmmid LEFT OUTER JOIN
dbo.p_NClass zzmmname ON zzmmid.rscode = zzmmname.ncl_ID AND
zzmmname.ncl_ClassID = '7' ON peple.p_zzmm = zzmmid.gacode AND
zzmmid.rsziduan = 'p_zzmm' AND zzmmid.gaziduan = 'A0141'
这是我在sqlserver中写的代码,那位高手能帮我转换成Access中的查询语句