KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Right now I'm running SELECT formula('FOO') FROM table1 WHERE table1.foo = 'FOO' && table1.bar = 'BAR'; but I would like to run this not on the constant FOO but on each value from the query SELECT foos FROM table2 WHERE table2.bar = 'BAR'; How can I do this? Edit: Important change: added FOO to the arguments of function. Illustration: SELECT foo FROM table1 WHERE foo = 'FOO' && table1.bar = 'BAR'; gives a column with FOOa, FOOb, FOOc. SELECT formula('FOO') FROM table1 WHERE table1.foo = 'FOO' && table1.bar = 'BAR'; gives a single entry, say sum(FOO) (actually much more complicated, but it uses aggregates at some point to combine the results). I want some query which gives a column with sum(FOO1), sum(FOO2), ... where each FOOn is computed in like manner to FOO. But I'd like to do this with one query rather than n queries (because n may be large and in any case the particular values of FOOn vary from case to case).
Tags (comma-separated)
Save Edits
Cancel