select
t.col1,
t.col2,
a.col1,
b.somecolumn
VQ.a,
VQ.b,
VQ.e,
VQ.d,
VQ.f,
(select
t.status as a,
p.id as b,
p.permit as c,
p.des as d,
p.error_code as e,
p.cause as f
from table_A t
inner join table_B p on t.a = p.a
where p.c = 'license' and t.status = 'Fail'
) as VQ
from table_A t
join table_C a on t.col1 = a.asset_id
join table_b b on t.somecolumn = b on somecolumn;
When I execute the above code, I encounter the error
SQL Error [42601]: ERROR: navigation on column "vq" is not allowed as it is not SUPER type
I am trying to do a select inside select.
select
inside another one, unless it is a single value. And it's anyway rather strange, as the subquery is not correlated to the outer query. What are you actually trying to do?table_B
on the outer query and remove the subquery completely. Sample data and expected results would help