Can I Join two tables with Partially matched fields
Posted on 2008-11-16
I think there are ways to have a Join two table with partially matching fields of each table. But Only exact match were found in the help. Please Help me
Say, i have a table
3 Pizzahut Rest.
Than I wanto have a resulting table like this
id AddrCode Field
1 AA-bbb PizzaHut
2 AA-bbb PizzaHut
3 AA-bbb PizzaHut
Direct Query Statement For Access(SQL) is fine.
or Direction via UI is also o.k
Thanks in advance