Relation not gfound in view Error

Started by Michael Blackover 17 years ago1 messagesgeneral
Jump to latest
#1Michael Black
michaelblack75052@hotmail.com

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 existSQL state: 42P01
But when I run the defination as a simple select statement, I do not get an error.

Any ideas?

TIA
Michael