i've 2 tables, for instance, employee and job. my job table has three fields(employee1,employee2,employee3 where all the three r different but compulsorily associated with a job) which contains employee code(foreign key) and employee code being the primary key of my employee table. if i have to print the records from the job table, i wud like to print the names of all the three employees related to the job instead of the code that is stored which obviously means that i've to maintain a relationship with these two tables. only one relationship is recognized, printing the same name thrice. what is the best possible solution without creating an other table ?