为什么CONCAT(b.familyName,b.givenName) as allname2 联合字段不能参与where??? select CONCAT(b.familyName,b.givenName) as allname2 from UserEntity b where b.allname2 = 'adrn'提示错误 不能这样使用
select CONCAT(b.familyName,b.givenName) as allname2 from UserEntity b where CONCAT(b.familyName,b.givenName) = 'adrn' orselect * from ( select CONCAT(b.familyName,b.givenName) as allname2 from UserEntity) b where b.allname2 = 'adrn'
select CONCAT(b.familyName,b.givenName) as allname2 from UserEntity b where CONCAT(b.familyName,b.givenName)= 'adrn'改成这个试试。
字段名不是属于表本身的,不能在where里面直接引用
select CONCAT(b.familyName,b.givenName) as allname2 from UserEntity b having allname2 = 'adrn'
where CONCAT(b.familyName,b.givenName) = 'adrn'
orselect * from (
select CONCAT(b.familyName,b.givenName) as allname2 from UserEntity) b
where b.allname2 = 'adrn'