SELECT *
INTO #newtable
FROM (select wp.PickListNo,wp.OrderNo,wp.ArtNo,wp.Aielse_Code from
wms_picking wp
inner join
wms_loose_transaction lt
on wp.PickListNo=lt.StatusTemp
where wp.PickListNo='PKL035311'
and left(lt.monoboxno,7)='1619199')
Msg 102, Level 15, State 1, Line 9
Incorrect syntax near ')'.