Code: Select all
...
...
WHERE (
SELECT SUM(table2.cost)
FROM `table2`
WHERE table2.id = table.table2id
) <= table.totalModerator: General Moderators
Code: Select all
...
...
WHERE (
SELECT SUM(table2.cost)
FROM `table2`
WHERE table2.id = table.table2id
) <= table.total