我写了一个SQL语句如下:select realname,client_level,
(select comclass.company from comclass where comclass.idclass=organ.idclass) as organ_company,
regdate from organ where organ.organ_company='5'
这样执行就报错:
#1054 - Unknown column 'organ.organ_company' in 'where clause' 如果这样执行select realname,client_level,
(select comclass.company from comclass where comclass.idclass=organ.idclass) as organ_company,
regdate from organ
就没有错误。我只是多加了一个where条件,我是哪里出错了,请各位前辈指正。
(select comclass.company from comclass where comclass.idclass=organ.idclass) as organ_company,
regdate from organ where organ.organ_company='5'
这样执行就报错:
#1054 - Unknown column 'organ.organ_company' in 'where clause' 如果这样执行select realname,client_level,
(select comclass.company from comclass where comclass.idclass=organ.idclass) as organ_company,
regdate from organ
就没有错误。我只是多加了一个where条件,我是哪里出错了,请各位前辈指正。
id idclass
1 12
1 13comclass 表
idclass company
12 5
13 6 表结构就这样
select realname,client_level,
(select comclass.company from comclass where comclass.idclass=organ.idclass) as organ_company,
regdate from organ where organ_company='5'
(select comclass.company from comclass where comclass.idclass=organ.idclass) as organ_company,
regdate from organ where organ_company.company='5'