|
Posted by SQL Learner on 01/18/07 15:54
Hi All,
I need to link two tables using partial word match.
How can I write a SQL statement to do so? (I am using MS-Access.)
Table One: [Table Name: tblStreet] [Field Name: Street]
123 ABC Street
124 ABC Street
125 ABC Street
1 XYZ AVE
2 XYZ AVE
3 XYZ AVE
10 CBS Street
11 CBS Street
12 CBS Street
100 Apple Road
101 Apple Road
102 Apple Road
Table Two: [Table Name: tblWord] [Field Name: Word]
ABC
CBS
The output should be:
123 ABC Street
124 ABC Street
125 ABC Street
10 CBS Street
11 CBS Street
12 CBS Street
Could this be done?
Thank you in advanced.
- Grasshopper -
Navigation:
[Reply to this message]
|