I've created a view in the database that joins 6 different database objects together. Before I created the view, I ran the select statement in the view and it returns all the records that I need. But, when I do a select on the view, it does not return anything.
Is there some type of statement that I need to include in my view that will show me all the records?
Thanks in advance you any help that you can provide me.