Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.