Hi:
I am sure that this question is not new but I could not find a reference in this forum, but here it is:
I have two tables (TABLE A and TABLE B). TABLE A contains a list if school names and TABLE B also contains school names and other school information. Unfortunately, TABLE A's school name may be different than TABLE B's school name. So I have to look up TABLE A's school name in TABLE B and find the matching school. I would manually set the value up in TABLE A to search TABLE B. What would the query look like ?
Note: Each individual value in TABLE A would need to check all the records in TABLE B to determine if there is a match.
Your assistance would be gladly appreciated. Thanks.
fb
I am sure that this question is not new but I could not find a reference in this forum, but here it is:
I have two tables (TABLE A and TABLE B). TABLE A contains a list if school names and TABLE B also contains school names and other school information. Unfortunately, TABLE A's school name may be different than TABLE B's school name. So I have to look up TABLE A's school name in TABLE B and find the matching school. I would manually set the value up in TABLE A to search TABLE B. What would the query look like ?
Note: Each individual value in TABLE A would need to check all the records in TABLE B to determine if there is a match.
Your assistance would be gladly appreciated. Thanks.
fb