SELECT T_USERS.USER_NAME , NULL APPLICATION_NAME , NULL OBJECT_TYPE , NULL OBJECT_NAME , TRUNC(T_USER_LOGIN_INFO.LOGIN_TIME) ACCESSED_TIME, '1' COUNT FROM TAS.T_USER_LOGIN_INFO T_USER_LOGIN_INFO , TAS.T_USERS T_USERS WHERE T_USERS.USER_ID = T_USER_LOGIN_INFO.USER_ID UNION ALL SELECT T_USERS.USER_NAME , T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_FAVOURITES_HISTORY.OBJECT_TYPE , T_GPS_FAVOURITES_HISTORY.OBJECT_NAME , TRUNC(T_GPS_FAVOURITES_HISTORY.ACCESSED_TIME) ACCESSED_TIME, '1' COUNT FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS , STATEGPS.T_GPS_FAVOURITES_HISTORY T_GPS_FAVOURITES_HISTORY , TAS.T_USERS T_USERS WHERE T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_FAVOURITES_HISTORY.APPLICATION_ID AND T_USERS.USER_ID = T_GPS_FAVOURITES_HISTORY.DBV_USER_ID