I have an Employee table that has a primary key. This key is used in another table for both a Welder column and a Operator Column.
How can i get the query to show two different results.
EX. we have a robots that weld. The welder would be RO1 but the operator would be NG.
here is the query i wrote.
TB_EMP.EMP_INT AS "WELDER",
TB_EMP.EMP_INT AS "OPERATOR",
JOIN TB_EMP ON TB_EMP.TB_EMP_KEY = TB_INSPECTIONS.INS_WELDER
JOIN TB_JOB ON TB_JOB.TB_JOB_KEY = TB_INSPECTIONS.TB_JOB_KEY