InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 07:48:48 GMT20http://forum.strataframe.net/FindPost6282.aspxI just tried to create a view in the DDT based on a Union query. The view looks something like this:<br> <br> Select Distinct<br> us_pk<br> ,pm_id<br> ,pm_key<br> ,up_action<br> From SFSUserPermissionInfo<br> <br> Union<br> <br> Select Distinct<br> us_pk<br> ,pm_id<br> ,pm_key<br> ,up_action<br> From SFSUserRolePermissionInfo<br> <br> When I save it, it reports the following as the columns:<br> <br> Column Table<br> ----------------- --------------------------------------<br> pm_pk SFSPermissions<br> pm_pk SFSPermissions<br> pm_key SFSPermissions<br> pm_Key SFSPermissions<br> up_Action SFSUsersXPermissions<br> rp_Action SFSUsersXRoles<br> Distinct| us_pk SFSUserPermissionInfo| || Union<br> Distinct| us_pk SFSUserPermissionInfo| || Union<br> <br> I deployed it and built a BO off of it and all seems to work, but the columns/tables are weird. I'm assuming that there are no significant ramifications of this, but I'd like to be sure all is OK.Fri, 26 Jan 2007 07:45:29 GMTGreg McGuffeyhttp://forum.strataframe.net/FindPost6288.aspxI am sure that it is fine.&nbsp; The view is deployed through SMO and at times the columns can be rearranged under certain circumstances.&nbsp; You should be fine.Fri, 26 Jan 2007 07:45:29 GMTTrent L. Taylor