SELECT   InvMaster.StockCode, InvMaster.Description, AdmFormData.KeyField, AdmFormData.FieldName
FROM    InvMaster LEFT OUTER JOIN
         AdmFormData ON InvMaster.StockCode = AdmFormData.KeyField
WHERE   (AdmFormData.FieldName = 'NAFTA') or (AdmFormData.FieldName IS NULL)

EDIT:...

Well it is quite possible that we complicate things, made to be easier.:-)

IT provided me that user, attached to all users login (authenticated windows ). I know...

Beautiful! Txs a lot.

db_datareader was already added manually but it doesn't seem to work.

SELECT 'GRANT SELECT ON [' + TABLE_SCHEMA + '].[' + TABLE_NAME + '] TO [MyUser];'

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'BASE TABLE';

This...