postgresql 字符串拼接"||“的使用 

SELECT  cust_id, com.com_name,com.contact,com.cell,com.pro || com.city || com.county || com.address AS dizhi FROM huiyuan  INNER JOIN com   ON huiyuan.id=com.cust_id WHERE  huiyuan.id=62303

 

posted @ 2021-03-04 15:51  小白膜拜大佬  阅读(1007)  评论(0)  编辑  收藏  举报