Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Delete Query + inner join

Why? how should it work??
I'm trying to delete rows from "tmp_fdfac" and it says "Incorrect syntax
near the keyword 'inner'"...... this is the query:
----------------
Delete from tmp_fdfac inner join WREP_fdfac_XX on tmp_fdfac.cliente=WREP_fdfac_XX.cliente
----------------
Thanks.
[320 byte] By [Carlos] at [2007-11-9 21:09:06]
# 1 Re: Delete Query + inner join
G'day Carlos.

Try this:

Delete tmp_fdfac from tmp_fdfac inner join WREP_fdfac_XX on tmp_fdfac.cliente=WREP_fdfac_XX.cliente

HTH,
Cheers,
Paul
Paul Mc at 2007-11-11 23:54:21 >