SQL语句-将两张表同一个字段的不同内容拼接在一起

SQL语句-将两张表同一个字段的不同内容拼接在一起

select 
    USER_ID,
    b.ORGNAME||'-'||a.ORGNAME EJYX 
from 
    HT_SYS_ORGANIZATION_USER c,
    HT_SYS_ORGANIZATION  a join HT_SYS_ORGANIZATION b on a.PARENT=b.ID 
where 
    a.ID = c.ORGANIZATION_ID and c.USER_ID='${ID}'