Be seen. Boost your question’s priority for more expert views and faster solutions
Can anyone explain why this doesn't work:
Select n.ID_NO,c.REMINDER_GROUP,c.CUST_NO,n.NAME_TYPE from TTT.NAME n, TTT.CUSTOMER c where c.CUST_NO = n.ID_NO and c.REMINDER_GROUP <> 3 and n.NAME_TYPE = 1
And neither does this:
update TTT.CUSTOMER c set c.REMINDER_GROUP = 3 where c.CUST_NO = TTT.NAME.ID_NO and c.REMINDER_GROUP <> 3 and TTT.NAME.NAME_TYPE = 1
Thanks for any help!
update cust set cust.REMINDER_GROUP = 3 on TTT.CUSTOMER cust inner join TTT.NAME n where cust.CUST_NO = n.ID_NO and cust.REMINDER_GROUP <> 3 and n.NAME_TYPE = 1