ACCESS the two fields in the table how

Table: ceshi

ID field is A field B
Haidian of Beijing haidian district, A district 1
2 xuhui in huangpu village
B
I want to find the field B contains A data is also find ID1

Purpose is to judge of seat of registered permanent residence village field (A) and now lived fields (B) whether the same region

SQL="select * from ceshi where great god help" thank you very much