An SQL puzzle
Check out this little snippet of SQL:
[sourcecode language="sql"]
SELECT PRAMvtID,
PRAMvtRALoadDteTme,
PRAMvtRAStatus,
PRAMvtRAType,
PRAMvtRAApprvlStatus,
PRAMvtCompany,
PRAMvtDeliveryNetwrk,
PRAMvtMeasurePoint,
PRAMvtSalesMonth,
PRAMvtTicketNo
INTO #complete_tkts
FROM PAPRAMovement d
WHERE PRAMvtID IN (SELECT PRAMvtID
FROM PAPRAMovement dd
WHERE dd.PRAMvtCompany = d.PRAMvtCompany
AND dd.PRAMvtDeliveryNetwrk =
d.PRAMvtDeliveryNetwrk
AND dd.PRAMvtMeasurePoint =
d.PRAMvtMeasurePoint
AND dd.PRAMvtSalesMonth = d.PRAMvtSalesMonth
AND dd.PRAMvtTicketNo = d.PRAMvtTicketNo
AND dd.PRAMvtRAStatus = 'C' )
[/sourcecode]