please mention more details here... in your query there

is col1 = d.col1... I think you are probably trying to do a.col1

How did you create this view?