Using Sage 100 ERP v2017. I am trying to run a very basic MS Excel query in order to build a database for our new website. Literally, all I am trying to get is the product part number, description and the name of the item image. My query is as follows:

SELECT IM_ItemCost.ItemCode,
       IT_Item.ItemName,
       IT_ItemAttachment.ThumbnailImage
FROM IM_ItemCost IM_ItemCost,
     IT_Item IT_Item,
     IT_ItemAttachment IT_ItemAttachment
WHERE IM_ItemCost.ItemCode = IT_Item.ItemCode
  AND IM_ItemCost.ItemCode = IT_ItemAttachment.ItemCode
  AND IT_Item.ItemCode = IT_ItemAttachment.ItemCode
ORDER BY IM_ItemCost.ItemCode

Instead of returning several thousand lines, I get 11 lines. This is not a new database or anything like that . There is no limit on number of lines to show. As you can see, there are no filters of any sort. I have confirmed that at least some of the missing items are "Internet enabled". On a few items, there was missing Item Name or missing Category and I was able to correct the situation but that only fixes some of them. Many of the missing Items have the information fields completed and are marked as Internet enabled but they will not show on the query when I tell it to refresh.

I have even restarted both Sage and Excel. I don't have the module that would allow me to export the data from Sage nor do I have Visual Basic or anything like that. I am I blind to something right in front of me or is there something else going on?