Pattern matching to look up ID?
Can I use MATCH to look up for ID in another table? Example: Table1 LkID LkName ------ --------- 1 is 2 what Table2 ID Name -- --------- 1 good morning 2 xyz 3 this is a test I want to return the result from table2, and LkID from table1. In this sample, it should return the LkID=1 for ID=3.
0
Comments