求一SQL查询语句.! ( 积分: 100 )

SELECT a.*,b.type_name,d.transg_phenom,c.ent_size_descri
from exe_illegal_gist_type b,
EXE_LAW_GIST a
left join exe_transg_phenom d on a.gist_id=d.gist_id
left join exe_gist_sort c on a.gist_sort_id =c.sort_id where a.gist_type_id=b.type_id

意思就是这样..连接两个表..这个语句不能通过..该怎么写..ACCESS数据库.!

Access不支持交叉数据

SELECT a.*,b.type_name,d.transg_phenom,c.ent_size_descri
from ((EXE_LAW_GIST a left join exe_illegal_gist_type b on a.gist_type_id=b.type_id) left join exe_transg_phenom d on a.gist_id=d.gist_id)
left join exe_gist_sort c on a.gist_sort_id

TO siking
先谢谢了..!不过你的也不能通过. 提示: 不支持连接表达式

难道一次一次查..