An Access97 MS SQL Book?

[Milin]

Is there such a thing out there as a book like &quot;Learn MS Access97's SQL Language?&quot; I understand that SQL comes in different &quot;flavors&quot; but as a beginner, I'm frustrated that I seem to have no definitive source on MSA's version of the language - I was told that MS SQL Server is even different..is that true? I have one SQL book and it is very good, but generic.<br>
<br>
Any thoughts or recommendations?<br>
Thanks!

 

[JimHorton]

Milin,<br>
The JET Database Programmers Guide has a fairly decent section on SQL, tailored, of course, to MS Sql. You are on the right track, though, in wanting to learn SQL instead of depending on Access' GUI query design grid. The design grid is a good way to jumpstart you in learning SQL--by designing a gui query and then going into SQL view to see the results. The next step is totally abandoning the design grid and writing sql 'by hand'. This may take more time but it will serve you well if you start using, say, DB2/400 SQL which, of course, has no GUI query design, or Oracle, which, for instance, doesn't use the JOIN keyword. <br>
--Jim