最近在用了下好久不用的access数据库。发现left join 和mysql的写法有些不一样记录一下。
access 左链接 层层都要加括号”()”。
mysql left join

View Code MYSQLselect h.*,ht.HouseTypeName,rt.RegionName,st.SubwayName from house h
left join HouseType ht on ht.ID = h.HouseTypeID
left join RegionType rt on rt.ID = h.RegionTypeID
left join SubwayType st on st.ID = h.SubwayTypeID
group by h.id order by h.id desc

access lef join

View Code ACCESSselect h.*,ht.HouseTypeName,rt.RegionName,st.SubwayName from
(
( (house h left join HouseType ht More >