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!