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

Leave a Reply

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