Click to See Complete Forum and Search --> : mysql: left vs inner joins


mitya
12-07-2005, 04:52 AM
I'm sure this has probably been asked before and, don't worry, I have searched the forums and found some answers.

BUT does anyone know any links to exampls of the two joins? I've got explanations, sure. But I feel I'd better understand what left joins do (over inner ones) if I could see an example of the output you'd get on a simple DB.

Unless anyone has the time or inclination to write one? Thanks in advance.