Clark - 3:10 pm on Jun 3, 2003 (gmt 0)

Thanks Sun. You clarified a few things for me I was uncertain about.

I'm also still a bit confused on JOINS. I've fooled around and experimented (besides reading..which helped me understand it WHILE reading but never to retain in my head the meaning of the different joins).

The only JOIN I ever remember using was LEFT JOIN. I remember cases where I thought RIGHT JOIN would work, but it didn't and LEFT did.

Anyone have a clear, concise and ez way to understand the different JOINS.

Also, am I the only one that finds the typical documentation for say MYSQL or PHP to be rather confusing unless you actually already understand the concepts behind what they're saying? IOW, if you understand the concept, it does a great job of explaining how MYSQL handles that function, but if you don't know already what the function does, you really have to work hard to get it.