Here is another screenshot so we don’t spend time going down the wrong rabbit hole. Again, I’ve tried many different combinations of settings. I’ve also tried saving a draft too, in addition to publishing + posts vs. pages. Pretty much every combination I could imagine (some fields, more fields, etc.)
For some reason, the first screenshot did not pick up the table name. I have tried different combinations of tables, views and they all link. So, I’m somewhat convinced it is not a connection issue.