Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00411
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Model_Number_MSTR
Physical Name: SV00411
Technical Name: SV_Model_Number_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Manufacturer_ID 
Manufacturer ID STR15_LBAU String 15 2 Wennsoft_Model_Number Wennsoft Model Number STR20 String 20 3 Model_Description Model Description STR40 String 40 4 MODIFDT Modified Date DT Date 8 5 Modified_Time Modified Time TM6 Time 6 6 MDFUSRID Modified User ID STR15 String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SV_Model_Number_MSTR'].MDFUSRID AS 'SV_Model_Number_MSTR-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SV00411 AS ['SV_Model_Number_MSTR']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SV_Model_Number_MSTR'].MDFUSRID = ['Users Master'].USERID