SET @SQL = NULL;
SELECT
GROUP_CONCAT(
DISTINCT CONCAT(
'MAX(IF(a.code = ''',
CODE,
''',a.rejectQuantity, 0)) AS ''',
CONCAT(mm, '/', dd),
''''
)
) INTO @SQL
FROM
reject;
SET @SQL = CONCAT(
'Select b.*,',
@SQL,
' From reject a
right join bom b
on a.code = b.code
Group by dd'
);
PREPARE stmt
FROM
@SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SELECT
GROUP_CONCAT(
DISTINCT CONCAT(
'MAX(IF(a.code = ''',
CODE,
''',a.rejectQuantity, 0)) AS ''',
CONCAT(mm, '/', dd),
''''
)
) INTO @SQL
FROM
reject;
SET @SQL = CONCAT(
'Select b.*,',
@SQL,
' From reject a
right join bom b
on a.code = b.code
Group by dd'
);
PREPARE stmt
FROM
@SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;