大写多表中的特定列SELECT(MySQL)

我试图以大写显示一个特定的列,但是我不能在选择多个表格时进行操作。 谢谢你的帮助。

表格1

id - name - last_name

TABLE_2

id - person_id - 金额

SELECT * FROM table_1,table_2,UPPER(table_1.name)WHERE table_1.id = table_2.person_id


选定的列首先(表格)

SELECT table_1.*, table_2.*, UPPER(table_1.name) as nameUpper FROM table_1, table_2 WHERE table_1.id = table_2.person_id
链接地址: http://www.djcxy.com/p/72723.html

上一篇: Uppercase a specific column in multy table SELECT (MySQL)

下一篇: Join 3 Distinct Tables in MySQL with no Common or Linked Column