I created two tables populated both with valid data including forgien key values. I create a view that uses both of these tables in a view that. When I select from the view, I get this error
ERROR: relation "vwsinglelevellist" does not exist SQL state: 42P01
But when I run the defination as a simple select statement, I do not get an error.