Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NLB11900
Product: SmartList Builder (3830)
Series: System
Display Name: Navigation List Restriction Users
Physical Name: NLB11900
Technical Name: NLB_Restriction_UsersSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Navigation_ID 
Navigation List ID STR15_LBAU String 15 2 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 3 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Navigation List Restriction Users'].USERID AS 'Navigation List Restriction Users-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NLB11900 AS ['Navigation List Restriction Users']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Navigation List Restriction Users'].USERID = ['Users Master'].USERID