Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT Procera.ip, SUM(Procera.total)+(SELECT total FROM ProceraNow WHERE ip = Procera.ip) AS 'Usage'
- FROM Procera JOIN ActiveLease
- ON Procera.ip = ActiveLease.ip AND Procera.date = ActiveLease.date
- WHERE Procera.date LIKE '02/%'
- GROUP BY Procera.ip
- ORDER BY 'Usage' DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement