Can someone explain table joins?
Does anyone know of a simple tutorial that explains how table joins work? I want to understand what actually happens in MySQL when you do a table join. In particular I want to know more about LEFT JOINs. It will make it a lot easier to understand how to use joins if I know what happens when you do one!
Devshed has an article www.devshed.com/Server_Side/MySQL/Join/page1.html , but it is kind of confusing. Kevin's book makes a good start on it, but I'd like an article that describes it a little more.
I shouldn't have slept in Algebra class
I'll try to decipher your reply....I think I'll drink some coffee first!
I definately should have tried hard in Algebra class!