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 ?
;
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