Yes you can do that. You need to identify the common column between them and use that to fetch data.
Product(SKU) like any other documents are also part of CMS_Document. So you should be able to find common columns between these two tables, CMS_Document & COM_SKU to get the missing columns.
Thanks,
Chetan