Okay so I'm new to sql. Digging on some websites I've found some examples that match my situation.
SELECT EMP_NUM,SUM(ASSIGN_HOURS) AS SumOfAssign_Hours,SUM(ASSIGN_CHARGE) AS SumOfAssign_CHARGE
GROUP BY EMP_NUM;
What if I have a column located on another table that I want to bring into this table query?
The above query works great for everything I need, HOWEVER, what if I want to bring in a column called EMP_LNAME for example from another table?
I understand that I probably have to use a join command somewhere, but to make it work without conflicting with my above queries is what I'm having issues with.
Any suggestions on how to bring in EMP_LNAME from another table that doesn't conflict with my script above?