|I would use a pivot
(SELECT UserId, ProductNum, Qty, 'passed' as status
SELECT UserId, ProductNum, Qty, 'finished' as status
SELECT UserId, ProductNum, Qty, 'scrapped' as status
) AS SourceTable
FOR status IN ('passed', 'finished','scrapped')
) AS PivotTable;
I havent tested this, but the principle should work.
I also have the opinion that you should normalize the database, several tables with the same content isn't good.
Put them together into one table with a status column.
People say nothing is impossible, but I do nothing every day.