I am not good with SQL, so I love the applymap() function which allows you to use a Foreign Key to lookup a value in another table.
Does EasyMorph have something similar?
I couldn't find anything - what's the best way to do this?
EG:
User Table
username: jp
Employee Table:
username: jp
fullname: john-paul dellaputta
applymap allows us to use the 'jp' value to return 'john-paul dellaputta' and add that as a new field or column.