MySQL 报错：优化 SELECT 查询语句，提升性能

这个SQL查询语句中存在一些优化的问题。\n\n1. 子查询不是必要的，可以直接在主查询中使用JOIN语句。将子查询中的表连接条件移动到主查询的JOIN语句中。\n\n2. 不需要使用GROUP BY语句，因为查询中没有使用聚合函数。\n\n下面是优化后的SQL查询语句：\n\nSELECT pbcb.warehouseCode, pw.chargeLocation, pbcb.chargeCategory, pbcb.chargeItemCode, pbcb.chargeItemName, pbcb.clientCode, pbcb.brandType, pbcb.netPrice, pbcb.plantCode, pbcb.whAttribute, pbcb.chargesType, pbcb.district, pbcb.feeDesc, pbcb.active, pbcb.userDef1, pw.locationCode as userDef2, NOW() as created, "$session.user" as createdBy, NOW() as lastUpdated, '$session.user' as lastUpdatedBy\nFROM peps_bms_charges_basic pbcb\nLEFT JOIN peps_whattribute pw ON pw.warehouseCode = pbcb.warehouseCode AND pw.userDef1 = pbcb.userDef1\nWHERE pbcb.warehouseCode IS NOT NULL AND pw.chargeLocation IS NOT NULL AND pw.locationCode IS NOT NULL AND pbcb.chargeItemCode IS NOT NULL