I added a distinct but it is still taking so long.  Did i put the distinct in the wrong places?

left join ( select distinct(shipment_id) from custom_cs.apj where apdelay > 0

union...

I will give it a try and let you know.

I added to the group by and it is really taking to long it is at 3000 seconds and this is just a select statement.  ARH table has 4000 approximate...

Thank you!

The case statement is running now. I appreciate it alot.

IF elseif is in green don't know why it isn't red as was the joins.  The joins in red are what is referenced to in the green if else if.

The...

• This reply was modified 2 years, 4 months ago by  chaunnahrailey@gmail.com.

I have one more issue just brought to my attention.  If the apdelay = 0 then No needs to be put into the delay field.

UPDATE tbl_salesactivity sn

INNER JOIN apj aj

ON...

UPDATE tbl_salesactivity_new sn

INNER JOIN arh ar

ON sn.shipment = ar.shipment_i

AND ar.ardelay > '0'

SET sn.delay = 'Yes'

I get an error From is not valid at this position expecting eof

Thank you and i appreciate you letting me know about attaching a doc.  My apologies and i will remember in the future.

Did you mean like the below?

update sn

set

sn.delay = 'Yes'

FROM

arh...

I tried the below but syntax is not correct.

update tbl_salesactivity_new

set

tbl_salesactivity_new.delay = 'Yes'

FROM

arh ar

inner join

tbl_salesactivity_new sn

on sn.shipment = ar.shipment_id

where arh.ardelay > 0