https://community.esri.com/t5/arcgis-pro-questions/create-database-view/m-p/1323879#M72609 <P>Hey guys! I created that sql expression below in Create Database View to simplify the users queries and it worked well, but I've acrossed with some issues.</P><P>When I made join i lost the&nbsp;fields subtype_codes. Then, it remains just the associated default value.</P><P>Is there a way to conserve subtype_code after doing that join tables?</P><LI-CODE lang="sql">SELECT adhp.name_txt, adhp.type_code, adhp.military_code, adhpsurfacearea.subtypecode, adhpsurfacearea.globalid, adhpsurfacearea.length_val, surfacecharacteristic.composition_code FROM adhp JOIN adhpsurfacearea ON adhp.gfid = adhpsurfacearea.adhp_id JOIN surfacecharacteristic ON surfacecharacteristic.gfid = adhpsurfacearea.surfacecharacteristic_id;</LI-CODE><P>In this case, the field is subtype_code from adhpsurfacearea.</P><P>Thanks in advance.</P><P>&nbsp;</P> Wed, 30 Aug 2023 13:16:00 GMT ammsgis 2023-08-30T13:16:00Z https://community.esri.com/t5/arcgis-pro-questions/create-database-view/m-p/1323879#M72609 <P>Hey guys! I created that sql expression below in Create Database View to simplify the users queries and it worked well, but I've acrossed with some issues.</P><P>When I made join i lost the&nbsp;fields subtype_codes. Then, it remains just the associated default value.</P><P>Is there a way to conserve subtype_code after doing that join tables?</P><LI-CODE lang="sql">SELECT adhp.name_txt, adhp.type_code, adhp.military_code, adhpsurfacearea.subtypecode, adhpsurfacearea.globalid, adhpsurfacearea.length_val, surfacecharacteristic.composition_code FROM adhp JOIN adhpsurfacearea ON adhp.gfid = adhpsurfacearea.adhp_id JOIN surfacecharacteristic ON surfacecharacteristic.gfid = adhpsurfacearea.surfacecharacteristic_id;</LI-CODE><P>In this case, the field is subtype_code from adhpsurfacearea.</P><P>Thanks in advance.</P><P>&nbsp;</P> Wed, 30 Aug 2023 13:16:00 GMT https://community.esri.com/t5/arcgis-pro-questions/create-database-view/m-p/1323879#M72609 ammsgis 2023-08-30T13:16:00Z https://community.esri.com/t5/arcgis-pro-questions/create-database-view/m-p/1323975#M72618 <P>It seems like you could join to the lookup table and display the values instead of the codes. It would follow this pattern:</P><LI-CODE lang="sql">SELECT adhp.name_txt, adhp.type_code, adhp.military_code, --adhpsurfacearea.subtypecode, LU.subtypevalue, adhpsurfacearea.globalid, adhpsurfacearea.length_val, surfacecharacteristic.composition_code FROM adhp JOIN adhpsurfacearea ON adhp.gfid = adhpsurfacearea.adhp_id JOIN surfacecharacteristic ON surfacecharacteristic.gfid = adhpsurfacearea.surfacecharacteristic_id JOIN [SUBTYPECODELOOKUPTABLENAME] LU ON LU.subtypecode = adhpsurfacearea.subtypecode</LI-CODE><P>&nbsp;</P> Wed, 30 Aug 2023 16:23:54 GMT https://community.esri.com/t5/arcgis-pro-questions/create-database-view/m-p/1323975#M72618 DougGreen 2023-08-30T16:23:54Z