Delete from multiple tables in one query
<cfquery datasource="#request.dsn#" name="delQry">
\n DELETE FROM
\n table_1, table_2
\n USING
\n table_1, table_2
\n WHERE
\n table_1.id = table_2.id
\n AND
\n table_1.id = 1
\n</cfquery>
\n DELETE FROM
\n table_1, table_2
\n USING
\n table_1, table_2
\n WHERE
\n table_1.id = table_2.id
\n AND
\n table_1.id = 1
\n</cfquery>
Learn more at www.mysql.com/delete