列名sql isull（）子句，其中
|
我无法在IdCell列上创建where子句，但可以执行\“ order by \”。
SQL Server对列名称说错误
select
*, (ISNULL(Table_Adresses.IdCellule, Table_Clients.IdCellule)) as IdCell
from Table_Tickets
left join Table_Postes on Table_Postes.IdPoste = Table_Tickets.IdPoste
left join Table_Adresses on Table_Adresses.IdAdresse = Table_Postes.IdAdressePhysique
left join Table_Clients on Table_Clients.IdClient = Table_Tickets.IdClient
where idtypeticket=2 and
isnull(bcloture,0)=0 and
IdCell =4 --problem here
order by IdCell
没有找到相关结果
已邀请:
4 个回复
芭隘的盘石
佬棠
的顺序构造查询，但是（有效地）它以的顺序执行。这就是为什么可以在子句中使用子句（\“列别名\”）而不在子句中使用的原因，即不在子句的范围内，因为它只会在以后出现。弦砂牧扁
select *, (ISNULL(Table_Adresses.IdCellule, Table_Clients.IdCellule)) as IdCell from Table_Tickets left join Table_Postes on Table_Postes.IdPoste = Table_Tickets.IdPoste left join Table_Adresses on Table_Adresses.IdAdresse = Table_Postes.IdAdressePhysique left join Table_Clients on Table_Clients.IdClient = Table_Tickets.IdClient where idtypeticket=2 and isnull(bcloture,0)=0 and (ISNULL(Table_Adresses.IdCellule, Table_Clients.IdCellule)) =4 order by IdCell稍惮
select *, (ISNULL(Table_Adresses.IdCellule, Table_Clients.IdCellule)) as IdCell from Table_Tickets left join Table_Postes on Table_Postes.IdPoste = Table_Tickets.IdPoste left join Table_Adresses on Table_Adresses.IdAdresse = Table_Postes.IdAdressePhysique left join Table_Clients on Table_Clients.IdClient = Table_Tickets.IdClient where idtypeticket=2 and bcloture is null and (ISNULL(Table_Adresses.IdCellule, Table_Clients.IdCellule)) = 4 order by IdCell