Table A
< table > < thead > < tr > < th align= "left" > id < / th > < th align= "left" > column1 < / th > < th align= "left" > column2 < / th > < / tr > < / thead > < tbody > < tr > < td align= "left" > 1 < / td > < td align= "left" > a < / td > < td align= "left" > A1 < / td > < / tr > < tr > < td align= "left" > 2 < / td > < td align= "left" > a < / td > < td align= "left" > a2 < / td > < / tr > < tr > < td align= "left" > 3 < / td > < td align= "left" > a < / td > < td align= "left" > A3 < / td > < / tr > < tr > < td align= "left" > 4 < / td > < td align= "left" > b < / td > < td align= "left" > b1 < / td > < / tr > < tr > < td align= "left" > 5 < / td > < td align= "left" > b < / td > < td align= "left" > b2 < / td > < / tr > < tr > < td align= "left" > 6 < / td > < td align= "left" > b < / td > < td align= "left" > b3 < / td > < / tr > < tr > < td align= "left" > 7 < / td > < td align= "left" > c < / td > < td align= "left" > C1 < / td > < / tr > < / tbody > < / table >Table B
< table > < thead > < tr > < th align= "left" > id < / th > < th align= "left" > column1 < / th > < th align= "left" > column3 < / th > < / tr > < / thead > < tbody > < tr > < td align= "left" > 1 < / td > < td align= "left" > a < / td > < td align= "left" > A1 < / td > < / tr > < tr > < td align= "left" > 2 < / td > < td align= "left" > a < / td > < td align= "left" > a2 < / td > < / tr > < tr > < td align= "left" > 3 < / td > < td align= "left" > b < / td > < td align= "left" > b1 < / td > < / tr > < tr > < td align= "left" > 4 < / td > < td align= "left" > b < / td > < td align= "left" > b2 < / td > < / tr > < / tbody > < / table > Table An and Table B are associated through the column1
field. The filter condition is that the value of column2
in Table A does not have a corresponding value in Table B"s column3
. According to the data in the table above, the result should be: