vb6/sql Incorrect syntax near the keyword ‘and’
Posted on 2014-02-21
I encounter the following error...
Run-time error ‘-2147217900 (80040e14)’:
Incorrect syntax near the keyword ‘and’.
Here's the code...
Select item.Inv_Units_Pack as UnitsPack, Sum(item.QOH) as TotQty, Sum(item.QOH) as Allocated, 0 as UnAllocated
from rpr_dev.dbo.item With (NOLOCK)
left outer join field_option_detail
on item.fo_allocation = field_option_detail.id_field_option_detail
inner join user_comp_permission
on item.id_company = user_comp_permission.id_company
WHERE id_item_header = 11354
Group BY item.inv_units_Pack and user_comp_permission.id_user = 37
Any Ideas on what is causing this error?
Thanks in advance