We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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.
|MULTIPLE DATE QUERY||15||103|
|update statement in oracle||9||40|
|Need help on decision table structure||7||46|
|I have 3 table called 1.Sales, 2.sales_copy, 3.sales_log_err respectively i have more than 3 million sales record i want to copy allsales record into sales_copy table and at the same time i wan||1||26|