Posted - 10/19/2005 : 7:58:13 PM


--------------------------------------------------------------------------------

Hi,

I having a problem when i write SQL statement for deletion using parameter. my statement as below:

delete tablea
from tablea as a ,tableb as b
where a.ord_no=b.ord_no
and b.ord_date=? (? is a parameter i had set into my DTS)

why it give me error as this:



Error source : Microsoft OLE DB Porvider for SQL Server

Error Description : The column prefix 'a' does not match with a table name or alias name used in the query.



anyone can you give me a advise how to resolve a problem as above!

Urgent!

Thanks


Jane