# 1.7 连接列值

问题：

查询多列的值，在一列上显示

解决方案：

```
select ENAME + 'work as a '+ job as msg from EMP where DEPTNO = 10;
```

结果：

![](https://3748388522-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRjpdT6PYM3zgtBC3PD%2F-Mda6WFXGl3PYHy5fGCB%2F-Mda9uRf_3vxAAZHVtlK%2Fimage.png?alt=media\&token=e1264b3b-8235-4542-b83c-23208508f83b)

###