看这里的例子 http://www.techonthenet.com/sql/update.phpUPDATE suppliers SET supplier_name = ( SELECT customers.name FROM customers WHERE customers.customer_id = suppliers.supplier_id) WHERE EXISTS ( SELECT customers.name FROM customers WHERE customers.customer_id = suppliers.supplier_id); 这个例子同你的很相像,把表名和字段名换一下即可。
这样做 insert into A表(username) select customername from B表 意思是把b表中customername的所有值都插入到a表的username中
我用了这么一句:update customer set CustomerName=(select company from leaddetails where leadid=customer.userid) 谢谢各位的回复啦~
http://www.techonthenet.com/sql/update.phpUPDATE suppliers
SET supplier_name = ( SELECT customers.name
FROM customers
WHERE customers.customer_id = suppliers.supplier_id)
WHERE EXISTS
( SELECT customers.name
FROM customers
WHERE customers.customer_id = suppliers.supplier_id); 这个例子同你的很相像,把表名和字段名换一下即可。
insert into A表(username) select customername from B表 意思是把b表中customername的所有值都插入到a表的username中
谢谢各位的回复啦~