[MSSQL] SubQuery 활용

select * from tblShipTicket
where ShipmentNo in (select ShipmentNo from tblShipPlan where PlanDay between '20160524' and '20160524')

delete from a
--select * 
 from tblLPR_IO a,
(select  IODateTime, IO, TASVehiNo, MAX(seq) as seq from tblLPR_IO
group by IODateTime, IO, TASVehiNo having count(*) > 1) b
where a.IODateTime = b.IODateTime
and a.IO = b.IO
and a.TASVehiNo = b.TASVehiNo
and a.seq != b.seq

UPDATE a
SET
a.Absorb_1 = (b.Val_01 + b.Val_02)
, a.Absorb_2 = (b.Val_03 + b.Val_04)
, a.Absorb_3 = (b.Val_05 + b.Val_06)
, a.Absorb_4 = b.Val_07
FROM absorb_master a
INNER JOIN tblAbsorbMaster_Sub b
ON a.Absorb_Line = b.Line
and a.Absorb_Date = b.Date
and b.Line = @sLine
and b.Date = @sDate