reapit/foundations

Relation between Manager and Negotiator

Closed this issue · 4 comments

Want to know, how to get the relation between Manager and Negotiator from snowflake datawarehouse.

Hi @adisingh789 please can you elaborate a little on what you are trying to determine? Is it the office manager you are talking about? Or the contact manager or property manager etc

Hi @plittlewood-rpt I want to know which table can be used to view the relationship between office manager and its office negotiators.

Hi @adisingh789 thanks - you should be able to do this fairly simply.

OFFICES has a field called MANAGER_NEGOTIATOR_ID which joins to NEGOTIATORS.ID however this is probably irrelevant here if you're already looking at the OFFICES table. You should just be able to run something like:

SELECT * FROM NEGOTIATORS WHERE OFFICE_ID = '[OFFICE.ID]' where OFFICE.ID is the id from the same row you're looking at in the offices table for a particular manager.

Does that answer your question?

Thanks!