Thank you,
OK,let me clarifiy.
look at first row (which col1 is a) in table1,it refer to A in table2,then in the view,it get all of rows in table2 which col1 is A and col2 is not 1
look at 2nd and 3rd rows(which col1 is b)in table1,it refer to A in table2,then in the view,it get all of rows in...