新国家标准《国民经济行业分类》(GBT4754-2011)数据库Access版本

/*获取所有门类*/ select * from [u_category] where dl='0' and zl='0' and xl='0' /*获取A门类下的大类*/ select * from [u_category] where ml='A' and zl='0' and xl='0' and dl<>'0' /*中类*/ select * from [u_category] where ml='A' and dl='1' and zl<>'0' and xl='0' /*小类*/ select * from [u_category] where ml='A' and dl='1' and zl='11' and xl<>'0'