sd_dracula sd_dracula - 1 year ago 98
SQL Question

sql selecting from view and table

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
where VIEW.col1 = TABLE.col1

I get
The multi-part identifier "VIEW.col1" could not be bound.

Is the syntax wrong, or is that just not allowed on views?

Answer Source

This should work

select v.col1, t.col2
from VIEW v, TABLE t
where v.col1 = t.col1
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download