Best way to learn SQL?

[VickreyAuction]

I need to learn SQL. Anyone who has done so, are there any books or website that are particularly good at teaching it? Any that I should avoid?

[amplify]

It's so easy that it doesn't matter where you learn it.
Select ____ where ____ and off you go.

[Warik]

http://www.w3schools.com/sql/default.asp

That'll teach you most of what you need to know. Anything else can be googled.

Don't waste your money on books.

[___SK___]

thanks for the link, glad i stumbled upon that.

[amplify]

its only the first hit for "learn SQL" in google.

[dogdrool]

Read over the mysql docs too. They're filled with examples, and might even have a tutorial.

[oneeye13]

[ QUOTE ]
http://www.w3schools.com/sql/default.asp

That'll teach you most of what you need to know. Anything else can be googled.

Don't waste your money on books.

[/ QUOTE ]

what he said

[iambusto]

use "from" in basic sql queries that you are constructing without help of a gui tool. If you want to build queries using a gui tool it uses inner join anyways

[moondogg]

[ QUOTE ]
use "from" in basic sql queries that you are constructing without help of a gui tool. If you want to build queries using a gui tool it uses inner join anyways

[/ QUOTE ]

Are you saying to do joins by "FROM a, b WHERE a.x = b.x" instead of using a JOIN statement? If so, why would you do that (assuming you are using a version of SQL that supports joins)?

[The DaveR]

[ QUOTE ]
It's so easy that it doesn't matter where you learn it.
Select ____ where ____ and off you go.

[/ QUOTE ]

You forgot "FROM"