SQLServer 2000 | select DEPT_ID+'#'+USER_ID,DEPT_ID as PARENT_ID,REAL_NAME from USER_P |
Oracle 10g | select DEPT_ID || '#' || USER_ID,DEPT_ID as PARENT_ID,REAL_NAME from USER_P |
MySQL 5 | SELECT CONCAT(DEPT_ID,'#',USER_ID),DEPT_ID AS PARENT_ID,REAL_NAME FROM USER_P |