La consulta fallo: select zc.z_clinic_id, zc.created::date as created, ao.name
from public.z_clinic zc
left join core.ad_org ao on ao.ad_org_id = zc.z_clinic_id
order by zc.created::date, ao.name; ...ERROR: relation "public.z_clinic" does not exist
LINE 2: from public.z_clinic zc
^