Hi!

Looks really weird. Something like 'inner outer join' ;)))

>In a query, I mistakenly used the syntax:
>
>1) select * from table_a outer join table_b on table_a.key = table_b.key
>
>instead I meant to code:
>
>2) select * from table_a left outer join table_b on table_a.key = table_b.key
>
>or
>
>3) select * from table_a left join table_b on table_a.key = table_b.key
>
>#1 appears to behave 'almost' like a left outer join. The same number
>of rows are returned as #2 and three, and same data, except:
>where null values show up in #1 - repeating values from table b show up -
>i think the first row.
>
>Does this syntax have any intended use ? Or is it just a mistake - if it
>doesn't return anything meaningful, shouldn't the compiler complain and not
>compile it ?
>
>TIA
>
>
>
>
>or 'left join'