How to use INNER JOIN on DELETE? 1

[3dColor]

I can't seem to delete where using a Inner Join.

DELETE 
FROM 	Stats INNER JOIN ListingParameter ON Stats.listingFk = ListingParameter.listingFk
WHERE 	Stats.listingFk = <cfqueryparam value='#FORM.ad#' cfsqltype='cf_sql_integer'>
AND ListingParameter.status = '0'

I get the following error:

Syntax error or access violation: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN ListingParameter ON Stats.listingFk = ListingParameter.listingFk ' at line 2

Do I have bad syntax?

 

[guelphdad]

delete from stats, listingparamater
where
Stats.listingFk = ListingParameter.listingFk
and
Stats.listingFk = <cfqueryparam value='#FORM.ad#' cfsqltype='cf_sql_integer'>
AND ListingParameter.status = '0'

also you need version 4.1 IIRC to do a delete where you name more than one table. It might be 4.0 though.