So, I understand that GUID fields aren't supported by shapefiles, and when you do a join manually in ArcMap (right click layer in TOC > join), it converts the GUID field to a string to join a table with a GUID to a shapefile. I figured it would do the same thing in arcpy as it does in ArcMap when using JoinField_management, but instead the tool fails. Is there any way to have that GUID field convert to string so I can join it with my shapefile? The only way I can think to do it is to copy the SDE database and change the GUID field to string field before joining it with my shapefile in arcpy, but I really want to avoid doing that as it isn't practical.