I have created a view to stage some data in a different format and then want to reference that view in a SQL query from a table that filters the data from the view using a property of the table.
MsgId = ReportId
) as ReportName
Is this even possible? When I try this, I get an error table not found for the view?