hi~ i'm just a less-exper. programmer, as i want to match up two table with special criteria. let's make and example:
i hv two table , A and B
Table A contain fields "ab1", "a2"
Table B contain fields "ab1", "b2"

then i want to match up table A and B with same field "ab1"
and also with field "ab1" which is equal to something special, say "one". how can i do it with coding methods~

pls hlp~
THX