Re: Left Join Support..?

ansi sql statement

	select a.column_1, b.column_1
	from a
	left join b on a.id=b.id

or in old sybase/microsoft terminology

	select a.column_1, b.column_1
	from a, b
	where a.id *= b.id

becomes

	select a.column_1, b.column_1
	from a, b
	where a.id (+)= b.id

in oracle.

Why they are not ansi compatible beats me.

-- 
¯`·.¸¸.·´¯`·.¸¸.·´¯`·.¸¸·´¯`·.¸¸·´¯`·.¸¸·´¯`·.¸¸·´¯`·.¸¸·´¯`·.¸¸·´


 The rules of morality are not the conclusion of
 our reason", David Hume

 Oystein Johnsen

 Premium Forvaltningsystemer AS		Office:	+(47) 224 37 598	
 Munkedamsveien 68			Mobile:	+(47) 928 90 254
 0270 Oslo
 Norway					mailto:oystein_at_premium.no
------------------------------------------------------------------