Query to Select List: SELECT * FROM opportunities LEFT JOIN accounts_opportunities ON accounts_opportunities.opportunity_id = opportunities.id LEFT JOIN accounts ON accounts_opportunities.account_id = accounts.id WHERE accounts.assigned_user_id = ‘7077c616-4f2c-f966-d9b6-5581807bae86’; UPDATE Query: UPDATE opportunities x LEFT JOIN accounts_opportunities y ON y.opportunity_id […]
Select List of Calls to Update: SELECT * FROM calls LEFT JOIN accounts ON calls.parent_id = accounts.id LEFT JOIN leads ON calls.parent_id = leads.id WHERE ( accounts.assigned_user_id = ‘7077c616-4f2c-f966-d9b6-5581807bae86’ OR leads.assigned_user_id = ‘7077c616-4f2c-f966-d9b6-5581807bae86’ ) ; Update Query: UPDATE calls […]
Same as previous post but this time with Accounts instead of Leads. List the Contacts related to the Accounts this employee has assigned: SELECT contacts.* FROM accounts INNER JOIN accounts_contacts ON accounts.id = accounts_contacts.account_id INNER JOIN contacts ON accounts_contacts.contact_id = contacts.id […]
I’m trying to update some records on Table C (contacts.assigned_used), but I have a Join from Table A (leads) and passing through in intermediary Table C. The query to show the filtered Table C (which is what I want to […]
The following Query get me a List of the Lines I want to Delete, but I cannot execute a query to Delete them. SELECT * FROM notes right JOIN a26_proveedor_notes_c ON a26_proveedor_notes_c.a26_proveedor_notesnotes_idb = notes.id WHERE notes.deleted IS NULL