--- In firebird-support@yahoogroups.com, "Trinidad Miravet Celades"
<tmiravet@n...> wrote:

> Maybe this could work ...
>
> select N.Name, L.LendDate
> from Names N
> left outer Join Lend L on (L.UserId = N.UserId and L.BookId = 100)

Thanks Trinidad!

Now, so I can understand the why's and where's of it, why does

====
select N.UserId, N.Name, L.LendDate, L.BookId

from Names N
left outer Join Lend L on (L.UserId = N.UserId and L.BookId = 100)
====

Works and

====
select N.UserId, N.Name, L.LendDate, L.BookId

from Names N
left outer Join Lend L on (L.UserId = N.UserId )
Where
L.BookId = 100
====

doesn't? Aren't they the same (in a logical manner of speaking?)

TIA
Andrew