update b set type= 'C' FROM table AS b left join othertable as c on b.id = c.id where b.type != 'C' and c.id !='NULL' update e SET can_wait = 1 FROM [SL].[dbo].[zz_customers] AS e LEFT JOIN sl.dbo.lkh_customer_supplier as c ON e.lkh_short_customer_name = c.lkh_short_customer_name WHERE c.lkh_customer_code IN (621,10144,2550,937,5,14,2232) 01.12.14 UPDATE e set slusa_moq = '0' FROM av0_style_extra AS e LEFT JOIN av0_style AS s on e.av0_style = s.av0_style where s.av0_code = '{}'; 01.12.14

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024