Good Book in SQL

[Niklas Östergren]

Hi

Anyone who know a good book for teaching myself SQL?

I have worked a while with Access (97 and 2002) and I have read a little VBA
but never any SQL. I´ve looked at the SQL-code after created the Q in the
designwindow for queries but I´d prefere a book beside me whan I wotk at the
computor.

TIA!
// Niklas

 

[James Goodman]

Not entirely sure, because Access has its own version of SQL with minor
differences (Jet SQL?). Unfortunately, I think most of the SQL books on
Access will pertain to running SQL Server with Access, & this then comes
under the umbrella of SQL Server TSQL, which is essentially ANSI SQL with
additions...

 

[Niklas Östergren]

Hmm, not so easy then!?

At least now I have leart me something new today, thanks James! ;-)

I guess I have to look around and see whats avalible in the bookstore. But
is there so big difference in which type of SQL I learn?

Or is the best way, inspite of alla, to create Q in Access and then read the
code?

Thank´s for a quick answer James!

// Niklas

 

[Ken Snell]

"SQL Queries for Mere Mortals" by Hernandez & Viescas (published by
Addison-Wesley) gives you an excellent start!

 

[Niklas Östergren]

OK!

I´ll look for this one!

Thanks!

// Niklas