Arno Brinkman wrote:

>Hi,
>
>
>>Select the values are different, so I guess this is a bug.
>>
>>Any Comments?
>>
>>
>
>Yes, those are correctly returning the same values. You're INNER JOINing the
>tables.
>
>Using sub-selects is probably the thing you want
>

Wouldn't a left outer join do the same thing? If so, what's the
advantage of a subselect?

>(i prefer sql-92 syntax
>instead of sql-89):
>

What do you mean by this?

Thanks!

Jonathan Neve.


[Non-text portions of this message have been removed]