Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT01000
Product: Extender (3107)
Series: Project
Display Name: Extender Activity
Physical Name: EXT01000
Technical Name: EXT_Extender_ActivitySeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Type 
Extender Type INT5 Integer 4 2 Extender_Form_ID Extender Form ID STR15_LBAU String 15 3 UD_Field_ID UD Field ID STR150 String 150 4 UD_Form_Field_ID_2 UD Form Field ID 2 STR30_LBAU String 30 5 Extender_Record_ID Extender Record ID Long Int Long Integer 8 6 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender Activity'].USERID AS 'Extender Activity-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT01000 AS ['Extender Activity']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender Activity'].USERID = ['Users Master'].USERID