SELECT inside SELECT in Redshift

Question

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.

Answer 1

I think you want this:

select
  t.col1,
  t.col2,
  a.col1,
  b.somecolumn
  VQ.a,
  VQ.b,
  VQ.e,
  VQ.d,
  VQ.f  
FROM (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
, table_A t 
join table_C a on t.col1 = a.asset_id 
join table_b b on t.somecolumn = b on somecolumn;
   
   

or something like that, perhaps.