| 1 | SELECT |
| 2 | m.GroupID, |
| 3 | v.CompanyName, |
| 4 | COUNT(*) AS Count |
| 5 | FROM |
| 6 | maintable_PCDRE m |
| 7 | JOIN |
| 8 | cb_vendorinformation v |
| 9 | ON |
| 10 | m.GroupID = v.GroupID |
| 11 | GROUP BY |
| 12 | m.GroupID, v.CompanyName |
| 13 | ORDER BY |
| 14 | Count ASC, m.GroupID DESC; |
| 15 |
Last active
| 1 | SELECT |
| 2 | m.GroupID, |
| 3 | v.CompanyName, |
| 4 | COUNT(*) AS Count |
| 5 | FROM |
| 6 | maintable_PCDRE m |
| 7 | JOIN |
| 8 | cb_vendorinformation v |
| 9 | ON |
| 10 | m.GroupID = v.GroupID |
| 11 | GROUP BY |
| 12 | m.GroupID, v.CompanyName |
| 13 | ORDER BY |
| 14 | Count ASC, m.GroupID DESC; |
| 15 |