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
one possibility is:
select distinct case when regdate = 1 THEN 'yes' when regdate = 2 THEN 'no' end as status_a , t2.id is null as test2exists from test1 t1 left join test2 t2 on t2.test1_id = t1.id