MySQLSugarCRM

MySQL: Query to find "Orfan" Notes on SugarCRM

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

Attachments:

Leave a Reply

Your email address will not be published. Required fields are marked *