I am a little confused about how I am going to update my query in number 1, you may refer to the attachment that I have included for your refererence, the instructions is on number 2 of the printscreen.
king03
0
Junior Poster in Training
urtrivedi
276
Nearly a Posting Virtuoso
Method 1) I assume that you must be having job_master table, so you can join that table on job_id and display job description from job_master table (hope fully same as "Shipping" and "Marketting Man"
Method 2) If you dont have job master table you can use case when then clause
select full_name,
case when substr(job_id,1,2) ='SH' THEN 'Shipping'
when substr(job_id,1,2) ='MK' THEN 'Marketting'
end job_description
from employees
It looks like class assignment so I will not write full query. You try on your own.
Also you need not to use group by or having clause, try to use simple where clause.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.