Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV01115
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Technician_Inventory_Sites
Physical Name: SV01115
Technical Name: SV_Technician_Inventory_SitesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Technician 
Technician STR10_LBAU String 10 2 LOCNCODE Location Code STR10_Location_Code String 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['SV_Technician_Inventory_Sites'].LOCNCODE AS 'SV_Technician_Inventory_Sites-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SV01115 AS ['SV_Technician_Inventory_Sites']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SV_Technician_Inventory_Sites'].LOCNCODE = ['Site Setup'].LOCNCODE