KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have following query in PostgreSQL: SELECT COUNT(a.log_id) AS overall_count FROM "Log" as a, "License" as b WHERE a.license_id=7 AND a.license_id=b.license_id AND b.limit_call > overall_count GROUP BY a.license_id; Why do I get this error: ERROR: column "overall_count" does not exist My table structure: License(license_id, license_name, limit_call, create_date, expire_date) Log(log_id, license_id, log, call_date) I want to check if a license has reached the limit for calls in a specific month.
Tags (comma-separated)
Save Edits
Cancel