Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/EXT21000
Product: Extender (3107)
Series: Project
Display Name: Extender Solutions
Physical Name: EXT21000
Technical Name: EXT_SolutionsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Extender_Solution_ID 
Extender Solution ID Long Int Long Integer 8 2 Extender_Solution_Name Extender Solution Name STR64 String 64 3 CREATDDT Created Date DT Date 8 4 CRUSRID Created User ID STR15_User_ID String 15 5 MODIFDT Modified Date DT Date 8 6 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Extender Solutions'].MDFUSRID AS 'Extender Solutions-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
EXT21000 AS ['Extender Solutions']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Extender Solutions'].MDFUSRID = ['Users Master'].USERID