Using the following query returns 0 (zero) records despite every IV41100 record having a value in the NOTEINDX column. How can this be? I ask because I would like to insert 50+ records via SSMS and don't know what values that I should be using (NULL values are not allowed).
SELECT
['Inventory Landed Cost'].NOTEINDX AS 'Inventory Landed Cost-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
IV41100 AS ['Inventory Landed Cost']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Inventory Landed Cost'].NOTEINDX = ['Record Notes Master'].NOTEINDX
Thank you,
James