SQL JOIN ?

From: Matthew O'Byrne <Iridium_at_netcomuk.co.uk>
Date: Mon, 27 Apr 1998 08:55:30 GMT
Message-ID: <6i1hef$4sb$1_at_taliesin.netcom.net.uk>



[Quoted] I've started altering an MS SQL application to work under Oracle 7.2/.3 Is it the case that Oracle SQL does not support the JOIN syntax (e.g. below) ? Does Oracle 8 ?
[Quoted] Presumably the alternative is changing all of the SQL to have WHERE clauses ?

e.g.
[Quoted] Select KeyName From Keys

	INNER JOIN UsersKeysLinks ON Keys.KID = UsersKeysLinks.KID 
	Where (UsersKeysLinks.ID = 10 )

;

Please respond, thank you. Received on Mon Apr 27 1998 - 10:55:30 CEST

Original text of this message