I have a select query in which I would like to do a join on a view and another table.
The view works fine and so does the table, separately. But when I try to do something like:
select VIEW.col1, VIEW.col2
from VIEW, TABLE
where VIEW.col1 = TABLE.col1
The multi-part identifier "VIEW.col1" could not be bound.
This should work
select v.col1, t.col2 from VIEW v, TABLE t where v.col1 = t.col1