SQL高手快来啊!!!

1、查Order_No(去掉重复的) 并写到临时表#tmp_BomChg_cacel 中，
select distinct Order_No into #tmp_BomChg_cacel from eos_om_order_abnr where Memo_Class in (select M_Class_name from eos_bas_memo_detail where Memo_Time between '2008-01-01' and '2008-01-31' order by order_no

2、更改表Tbl_Plan_MDisk的DeployTime字段，当它的order_no 在临时表#tmp_BomChg_cacel 中且order_no 以“E”开头，第三位不是“4”。
update Tbl_Plan_MDisk set DeployTime=null where ProductID in
(select order_no from #tmp_BomChg_cacel where order_no like 'E_[^4]%')

3、按Machine_No分类统计记录数到临时表#DMC_Packing
select Machine_No,count(*) as num into #DMC_Packing from Tbl_Pas_List_Packing group by Machine_No

4、用tbl_pas_order表中的plan_qty 更改临时表#tmp_finished中的plan_qty 字段。按前表中的lot_no与后表的order_no对应关系进行。
update a set plan_qty=b.plan_qty FROM #tmp_finished a join tbl_pas_order b on a.lot_no=b.order_no

能用上这些也就差不多了。

---

1、查Order_No(去掉重复的) 并写到临时表#tmp_BomChg_cacel 中，
select distinct Order_No into #tmp_BomChg_cacel from eos_om_order_abnr where Memo_Class in (select M_Class_name from eos_bas_memo_detail where Memo_Time between '2008-01-01' and '2008-01-31' order by order_no

2、更改表Tbl_Plan_MDisk的DeployTime字段，当它的order_no 在临时表#tmp_BomChg_cacel 中且order_no 以“E”开头，第三位不是“4”。
update Tbl_Plan_MDisk set DeployTime=null where ProductID in
(select order_no from #tmp_BomChg_cacel where order_no like 'E_[^4]%')

3、按Machine_No分类统计记录数到临时表#DMC_Packing
select Machine_No,count(*) as num into #DMC_Packing from Tbl_Pas_List_Packing group by Machine_No

4、用tbl_pas_order表中的plan_qty 更改临时表#tmp_finished中的plan_qty 字段。按前表中的lot_no与后表的order_no对应关系进行。
update a set plan_qty=b.plan_qty FROM #tmp_finished a join tbl_pas_order b on a.lot_no=b.order_no

能用上这些也就差不多了。

---

条件都没有写什么?
select * from tablename
-
insert tablename()values()
-
insert tablename()
select nion
select

delete table

---

mysql, orical,select,insert,update,delete还有数据库操作的象drop,create,use,

---

查询语句你要讲清楚什么查询,表结果如何
你这样我很难知道我要写什么给你哦

---

select * from aa a inner join (select * from bb where f3 in (select f4 from dd)) b on a.f1=b.f1 where a.f2 in (select f1 from cc)