This is just going to make everyone think I know nothing about programming, but I have to ask it. What are LEFT JOIN and RIGHT JOIN used for? I haven't ever used a script besides a bulletin board that used "JOIN" and I am not sure what it was used for because I had the bulletin board several years ago. I was just on the MySQL website and saw that JOIN was grouped in with some of the optimization documents, and I firgured it was time to learn.
If someone could give me an example of how it is used or just a brief demonstration that would be really helpful.
