多个条件查询;多个条件排序;关键字查询
select pk_account,cSpecs 规格,dDate 日期,cWorkName 单位,cAccept 进厂,cFinish 出厂,cTicketController 票管员,cPostLeader 岗长,cResponsible 责任人,cMemo 备注 from CM_ElectronicAccount where cAccountName = '结晶器铜管' and dDate like '%2020%' order by cSpecs,dDate "
多表联查删除
delete from 表1
where A = (select A from 表2 where 条件 = '')
and B = (select B from 表3 where 条件 = '')
多表联查
select
s.cNCCode 产品编号,
s.cNCName 产品名称,
s.cSpecs 规格,
s.cLength 型号,
wh.cWareName 仓库,
msb.iCount 件数,
msb.fWeight 重量
from
[GTWZ].[dbo].[EV_MoveStock_b] as msb,
[GTWZ].[dbo].[WI_SteelNC] as s,
[GTWZ].[dbo].[WI_WareHouse] as wh,
[GTWZ].[dbo].[EV_MoveStock_h] as msh
where s.pk_steelNC = msb.pk_steelNC
and msh.iOutStock = wh.pk_warehouse