How to delete rows from a table with cross join?

Question

I need to delete rows from a table using same join condition from this select:

SELECT CC.NO, CC.NOME,CC.DATALC,CL.u_datadm, cmdesc FROM cC
CROSS JOIN cl where cc.no=cl.no and cc.DATALC <cl.u_datadm

Need Help.

Thank You.

 

---

Answer 1

Deleted

Answer 2

Obrigado Rafael.

Vou experimentar.

JJ

---

Jimmy