@AdejumoBidemi What my colleague Shengdi stated above is the solution to your problem. The main goal is to use Query output results as the Table widget data source, and you can see the 5 states queried out of 51 displayed inside the Table in my example:
This should work without any surprises, but, if you are still experiencing this behavior with similar settings, maybe you could share your app for us to take a look?