SQL 选择 table1.column 作为 table1.column

Question

我正在处理数据库连接，我想执行以下操作:

Select tabel_one.id, 
       tabel_one.title, 
       tabel_one.content, 
       table_two.value as table_two.key 
  from tabel_one 
  Join table_two ON table_two.id = table_one.id ....

重要的部分是:

table_two.value as table_two.key

这有什么可行的方法吗？

Answer 1

不，您不能定义引用表的别名。

一般来说，你应该简单地使用:

table_two.value as key

否则，如OMG Ponies suggested in another answer , 你可以用反引号包裹别名:

table_two.value as `table_two.key`