可行:
select b.EMGNID,a.保存字段,a.显示字段,a.数据字典表名 from SysBaseDataDict a join FormInputUIControl b on a.ID=b.EMDictID where b.EMGNID=204
select b.EMGNID,a.保存字段,a.显示字段,a.数据字典表名 from SysBaseDataDict a join FormInputUIControl b on b.EMGNID=204 and a.ID=b.EMDictIDselect b.EMGNID,a.保存字段,a.显示字段,a.数据字典表名 from SysBaseDataDict a join FormInputUIControl b on b.EMGNID=204 where a.ID=b.EMDictID
错误:
select b.EMGNID,a.保存字段,a.显示字段,a.数据字典表名 from SysBaseDataDict a join FormInputUIControl b where a.ID=b.EMDictID and b.EMGNID=204select b.EMGNID,a.保存字段,a.显示字段,a.数据字典表名 from SysBaseDataDict a join FormInputUIControl b where b.EMGNID=204 and a.ID=b.EMDictID