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

Once you assigned an alias to a table, you should always be using that alias:

delete a
from tablea as a ,tableb as b
where a.ord_no=b.ord_no
and b.ord_date=?

SQL Server Helper
http://www.sql-server-helper.com