Case Expression on Vertica Question
I am trying to create a statement that will decide on a query to execute something like:
CASE WHEN 1
select a,b,c,d from table1
select e,f,g,h from table2
but I get the error: "Subquery must return only one column"
Is there a workaround for that somehow? I cannot see the "if" statements exist in Vertica also.
Thanks in advance,