question

klsmithmilw avatar image
klsmithmilw asked

Need delete statement for this query I wrote

Select eepnamelast, eepnamefirst, eecempno, eepeeid, ejhjobcode, EjhReason, EjhAnnSalary, EjhEEType,EjhEmplStatus, EjhHourlyPayRate, EjhIsJobChange, EjhJobEffDate,eecpaygroup, EjhPayGroup, EjhPayPeriod,EjhPeriodPayRate, EjhSalaryOrHourly, EjhScheduledAnnualHrs, EjhScheduledFTE,EjhScheduledWorkHours, EjhWeeklyPayRate, ejhdatetimecreated from emphjob join emppers on eepeeid = ejheeid join empcomp on eeceeid = ejheeid where eecpaygroup in ( 'ssphr') and ejhpaygroup != 'ssphr'
join
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

It would help if you shared what it was that you wanted deleting.
0 Likes 0 ·
You have three tables here. You can only delete from one at a time. You're going to have to better define what you're trying to do.
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.