How to write the query ?

[suvechha_b]

Hi All ,

Pull a report of all institutions that have more than one active consultant relationship.

A consultant has the CONSULTANT (id 6 in relationshiptype) relationship type to its institution in relationship with status_id = 2

Thanks,

[sunny_talwar]

Where is this query needed? Front end or back end? Can you provide more information?

[suvechha_b]

I need this in back end .

We got table relationship where institution_id , relationshiptype_id , status_id and member_id is present .

Consultant = relationshiptype_id  (6)

Status = status_id  (2)

[buzzy996]

it's good if u can provide ur input data and expected out!