2 rows of data in job table:
joid=111 <-- unique identifier
Here is my problem:
I want to have this select statement show me job_name and the "box name".
SELECT job_name,box_joid from job where job_name=JOB2
Right now, box_joid would show up as 111 in this statement. I want it to show up as JOB1 and that's where I'm stuck at. I don't know how to make the box_joid not show up as a number, but as the actual job_name of the job in which the box_joid=joid. I hope that makes sense.