Delete Statement Error
I having a problem when i write SQL statement for deletion using parameter. my statement as below:
from tablea as a ,tableb as b
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!