Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-29 : 08:12:28
|
| George writes "Hi. I am updating a DBF from a SQL Server DTS, using a SQL Task Property, but the update needs to link 2 tables, when I applied a SQL Statement like inner join or other SQL gives me a message "command contains unrecognized phrase/keyword"I've also connected with a DSN to apply the connection." |
|
|
cas_o
Posting Yak Master
154 Posts |
Posted - 2003-05-29 : 09:29:16
|
| Not sure what a DBF is?But I think maybe your data source doesn't understand T-SQL inner Join syntax I know Oracle doesn't for example.Try joining your tables in the WHERE clause for example:SELECT *FROM table1, table2WHERE table1.column=table2.column;-] |
 |
|
|
|
|
|
Update Statement on DBF in SQL Task Property