Error Code 1093

[Igor Kondrasovas]

Hello all,

I'm trying to perform the following command in MySQL, but I'm getting error code 1093. Could you please help me correcting it so I can use in MySQL?

I suppose I must use "sub queries", but I have no background on using them.

DELETE FROM as30.data_parameters_ca WHERE ID IN (

SELECT

Extent2.ID AS ID

FROM as30.data_parameters_ca AS Extent1

INNER JOIN as30.data_parameters_ca AS Extent2 ON (Extent1.SDATE = Extent2.SDATE)
AND (Extent1.CO2MAX = Extent2.CO2MAX)
AND (Extent1.CO2NOM = Extent2.CO2NOM)
AND (Extent1.O2MIN = Extent2.O2MIN)
AND (Extent1.O2NOM = Extent2.O2NOM)
AND (Extent1.CO2NOM = Extent2.CO2NOM)
AND (Extent1.FITEM = Extent2.FITEM)

WHERE Extent1.ID = (Extent2.ID - 1))

Kindly Regards,

Igor.

PS: I posted this thrad on the Newbie forum, but it seems here is the best place for this issue...