MySQL Query - List is not in GROUP BY clause and containts non-aggregrated column
Hello, i have had some assistance to setup an MYSQL query to interface with an inventory management software. We ran the SQL query out of the software no problems but when entering into Bartender I get the following error.
[500] Could not excecute the specified command: [42000] Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregrated column. 'database.trackingtext.info' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode = only_full_group_by (1055)
This query runs fine when entering directly into the database. Any ideas?
QUERY:
Select woitem.qtyused, part.num, part.description as description, product.sku, wo.datefinished
,tag.qty-tag.qtycommitted as qty
,Batch.Info as BATCH
,DATE(ExpDate.InfoFormatted) as EXPIRATION
,PID.Info as PALLETID
from woitem
left join wo on woitem.woid = wo.id
left join part on woitem.partid = part.id
left join product on part.id = product.partid
join tag on tag.partid = part.id
left join uom on part.uomid = uom.id
left join tagtrackingview batch on batch.tagid = tag.id and batch.parttrackingid = 5
left join tagtrackingview ExpDate on ExpDate.tagid = tag.id and ExpDate.parttrackingid = 3
left join tagtrackingview PID on PID.tagid = tag.id and PID.parttrackingid = 8
Join Location on LOcation.Id = Tag.LocationId
Join LocationGroup on LocationGroup.Id = Location.LocationGroupId
where wo.statusid = '40'
group by PALLETID
请先登录再写评论。
评论
0 条评论