Ravi Shekhar

Ravi Shekhar

  • 362
  • 4.5k
  • 2.1m

getting error

Aug 2 2013 5:49 AM
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 ')'.

Answers (7)