RE: [OJB-developers] SQLGenerator

[bram <br...@in...>]

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