Hi guys! I've got 2 tables, and I need to get some data between them.
test1: WITH account_status AS ( select CASE WHEN regdate = 1 THEN 'yes' WHEN regdate = 2 THEN 'no' from test1 end as status_a ) select status_a from account_status group by status_a test2: WITH user_status AS ( select CASE WHEN regdate = 1 THEN 'yes' WHEN regdate = 2 THEN 'no' from test1 join test2 as t2 on t2.test1_id = t1.id end as status_a ) select status_a from user_status group by status_a It works fine.. but I would like to get that data in one single query.. How can I do that? I'm using Postgres 9.3. Thanks! Patrick