在 Concat 语句中使用条件的结果

Question

本质上，我试图在紧随其后的 Concat 语句中使用条件的结果。

在我的SELECT声明中，我有以下内容：

IF (`Table1`.`Address1` IS NULL, `Table1 `.`Address2`, CONCAT_WS(",", Address1, Address2)) AS Shipping_Address,

CONCAT_WS(", ", Shipping_Address, Table1.City, Table1.State, Table1.Zip) AS AddressFull

但是当Shipping_Address条件内时，我没有得到任何结果，这意味着它似乎无法显示之前条件的结果。

第一个表达式的结果是否可以以某种方式用于其后面的 Concat？

Answer 1

Shipping_Address是列别名

您不能在选择中使用别名，您应该重新编写代码

IF (`Table1`.`Address1` IS NULL, `Table1 `.`Address2`, CONCAT_WS(",", Address1, Address2)) AS Shipping_Address,
CONCAT_WS(", ",IF (`Table1`.`Address1` IS NULL, `Table1 `.`Address2`, CONCAT_WS(",", Address1, Address2)), Table1.City, Table1.State, Table1.Zip) AS AddressFull