Re: [OJB-developers] SQLGenerator

[Oleg N. <on...@uk...>]

Thanks Bram!

Oleg

On Thursday 02 May 2002 22:21, you wrote:
> Examples
>
> Tables:
> A(id int, name varchar(10))
> B(id int, value varchar(10))
>
> Records A
> 1, "name1"
> 2, "name2"
>
> Records B
> 1, "value1"
>
>
>
>
> Sql92:
> Works with Mssql70, Mssql2000, postgresql, oracle 9(not checked, but
> dba-er says it works)
>
> 	Select a.name, b.value
> 	From a left outer join b on (a.id = b.id)
>
> 	Result:
> 	Name1, value1
> 	Name2, null
>
> Ms sqlserver 6.5/7.0/2000 syntax
>
> 	Select a.name, b.value
> 	From a , b
> 	where a.id *= b.id
>
> 	Result:
> 	Name1, value1
> 	Name2, null
>
>
> Oracle 8
> 	Select a.name, b.value
> 	From a , b
> 	where a.id = b.id (+)
>
> 	Result:
> 	Name1, value1
> 	Name2, null