Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL JOIN exist ?

SQL JOIN exist ?

From: Matthew O'Byrne <Iridium_at_netcomuk.co.uk>
Date: Mon, 27 Apr 1998 08:50:58 GMT
Message-ID: <6i1h5v$4qo$1@taliesin.netcom.net.uk> 





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 ?


Presumably the alternative is changing all of the SQL to have WHERE clauses ?



e.g.


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 - 03:50:58 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US