I am trying to join two tables and trying to distinct the id of parent table.
SELECT DISTINCT ON(management_company.id) * FROM management_company INNER JOIN buildings on m_id = management_company.id ;
I am trying to join two tables and trying to distinct the id of parent table.
SELECT DISTINCT ON(management_company.id) * FROM management_company INNER JOIN buildings on m_id = management_company.id ;
knex('management_company')
.distinctOn('management_company.id')
.join('buildings', 'm_id', 'management_company.id')