Lægge to tabellers felters indhold sammen...eller lign =)

Kan man ikke bare skrive:
SELECT admin, COUNT(*) as test FROM accepted, rejected GROUP BY admin ORDER BY test DESC;

Et skud uden test, prøv med

SELECT accepted.admin, accepted.COUNT(*) AS AcceptedCount, Rejected.COUNT(*) AS RejectedCount, (AcceptedCount+RejectedCount) AS TotalCount
FROM accepted LEFT JOIN rejected ON accepted.admin=rejected.admin
GROUP BY accepted.admin
ORDER BY TotalCount DESC

CREATE TEMPORARY TABLE tmp
SELECT admin, COUNT(*) AS acc, 0 AS rec FROM accepted GROUP BY admin;
INSERT INTO tmp
SELECT admin, 0 AS acc, COUNT(*) AS rec FROM rejected GROUP BY admin;
SELECT admin, SUM(acc) AS accepted, SUM(rec) AS rejected, SUM(acc)-SUM(rec) AS status FROM tmp GROUP BY admin ORDER BY status DESC, accepted DESC;
DROP TABLE tmp;

Den fra proaccess virkede. Tak.
De to felter skulle så lægges sammen, men dét kan jeg godt finde ud af :D