SELECT
Ba. *, ba. Id as ba_id, bv. *, bv. Id as bv_id
The FROM
Pms_base_attr_info ba,
Pms_base_attr_value bv
WHERE
Ba. Id=bv. Attr_id
And
Bv. Id in (${valueIdStr})


Error:
# # # Error querying the database. Cause: the mysql. JDBC. Exceptions. Jdbc4. MySQLSyntaxErrorException: You have an Error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near 'at line 9
# # # The error may exist in The file [F: \ yuan \ gmall - manage - service \ target \ classes \ mapper \ PmsBaseAttrInfoMapper XML]
# # # The error may involve defaultParameterMap
# # # The error occurred while setting The parameters
# # # SQL: SELECT ba. *, ba. Id as ba_id, bv. *, bv. Id as bv_id FROM pms_base_attr_info ba, pms_base_attr_value bv WHERE co. Id=bv attr_id and bv. Id in
# # # Cause: com. Mysql. JDBC. Exceptions. Jdbc4. MySQLSyntaxErrorException: You have an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near 'at line 9
; Bad SQL grammar []; Nested exception is com. Mysql. JDBC. Exceptions. Jdbc4. MySQLSyntaxErrorException: You have an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near 'at line 9, dubbo version: the server, the current host: 127.0.0.1