<p>I have fields from three tables I'm trying to join together. </p>
<p> </p>
<p>Daily_Assignment.shop_person</p>
<p> </p>
<p>Work_Order.editor</p>
<p> </p>
<p>Human_Resources.employee_id</p>
<p>Human_Resources.first_name</p>
<p>Human_Resources.last_name</p>
<p> </p>
<p> </p>
<p>These fields all contain an identical employee ID unique to each employee:</p>
<p>Daily_Assignment.shop_person,</p>
<p>Work_Order.editor,</p>
<p>Human_Resources.employee_id</p>
<p> </p>
<p>I want to be able put shop_person, and editor on the report, but have first_name and last_name displayed instead of the ID number</p>
<p> </p>
<p>I don't understand how to get Birt to display the correct first and last name without getting shop_person and editor confused with each other. </p>
<p> </p>
<div> </div>
