need to make a function using 2 sql tables
table1 has fields NAME, CITY, Dept, DESIG, COUNTRY & the rspective data
this table1 has the values for the above fields
table2 which has 2 fields FIELDNAME , ALIASNAME
FIELDNAME has all the field names from table1 ie
FIELDNAME , ALIASNAME
NAME Fullname
CITY City
Dept Department
DESIG Post
COUNTRY Coun
i need a query to get FIELDNAME , ALIASNAME along with values of NAME, CITY, DEPT from table1