id主键 emid hair face
1 001 good good
2 005 not good
3 018 good good
4 019 good good
5 020 not not
表一table1
id主键 emid within tone
1 001 good good
2 005 not good
3 016 good good
4 018 good good
5 020 not not
表二table2
id emid total
1 001 75
2 005 80
3 016 90
4 018 68
5 020 72
表三table3
要求用sql语句进行插入,成为表4
id emid table1 total table2
1 001 75
2 005 hair not within not
3 018 68
4 020 hair not face not 72 within not tone not
5
如何实现这个表四,total要求不大于80出现在表四,有not的出现在其他2个属性中.