select top 100
from erp.OrderHed as h (nolock)
join erp.OrderDtl as d (nolock) on h.OrderNum = d.OrderNum
where sourceSystem_c = 'iconnect' and ShipViaCode = 'wc'
I get this error message:
Incorrect syntax near the keyword 'from'.
from erp.OrderHed as h (nolock)
join erp.OrderDtl as d (nolock) on h.OrderNum = d.OrderNum
where sourceSystem_c = 'iconnect' and ShipViaCode = 'wc'
I get this error message:
Incorrect syntax near the keyword 'from'.
Comment