[thelist] SQL

[Fred Jones]

>  SELECT <columns> FROM <table a> LEFT JOIN <table b> ON <join clause>
>
> The above selects all the records in <table a>, whether or not there's
> a matching record in <table b>.  When there is no match, columns that
> would have come from <table b> are NULL.
>
> The same query with an INNER JOIN selects only the records in <table a>
> that have a matching record in <table b>.

right.

> (I hope I'm not just telling you what you already know.)

I did know it. I'm not as stupid as I look. But I tend to know it only
in theory and never use it in practice... I always forget that
anything exists except LEFT. :)

Thanks!