Some months ago we also put our SQL server 7 database to 2000 and a *lot* of
joins are used in the application and no problem was detected at all.
Everything was backward compatible.
"Lori" <lwagner6ford.com> wrote in message
news:0a4401c341a1$e8bd8360$a001280aphx.gbl...> I am looking to upgrade a database from SQL 7.0 to SQL
> 2000. The application that uses the database is written in
> VB 6.0 using ADO. Will I have problems with SQL that used
> JOIN syntax "where emp.empid = dept.empid"? An associate
> read that these must be changed to ANSI syntax using
> INNER, OUTER, ect. is this true? Are there any other
> issues I need to look out for?