i think i shall rephrase my question
coz it seems a bit blur. so sorry


imagine i have 2 table, A and B, if there is a similar field C
how can i place a SELECT statement which ensure the field C in A and B are equal??