Tutorial on Self-Joins?

Hi,

Could someone please point me to a very remedial tutorial on self-joins
(and maybe the other types of join statements)?

I understand the basic concepts -- I've done lots of simple SQL queries
and a few inner joins -- but still need something written in the most
accessible way possible, because I can pretty dense sometimes.

The tutorials I've found through a cursory Google search haven't been
very helpful to a novice.

I'm using an SQL server 2000 database.

Thanks.

Re: Tutorial on Self-Joins?

Not totally sure what you want to do with a self join but I suppose it
would be joining to an alias of the same table for some reason.

But here's a nice page about joins:

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

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips