Do I use ANSI Syntax or legacy syntax against an Access 2000 database?<BR><BR>I got a new book today "The Guru&#039s Guide to Transact-SQL"<BR>but it for the most part does not mention Access it primarily "Covers Microstft Transact-SQL"<BR><BR>My guess would be to use ANSI.<BR>But is that true, or is there a third language dialect?<BR>