using mysql5
table A
user smallint(3)
userA smallint(3)
userB smallint(3)
table b
employeeid smallint(3)
employeename varchar(20)
tableb data
1 John Doe
2 Jane Doe
3 Clark Kent
4 Mary Jane
tablea Data
1 2 4
2 3 1
3 1 4
Want to do a select on table A which will display the records as
John Doe Jane Doe Mary Jane
Jane Doe Clark Kent John Doe
Clark Kent John Doe Marj Jane








Bookmarks