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.


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file