Re: SQL JOIN exist ?

From: <Abeeda_Mohammed_at_xn.xerox.com>
Date: Mon, 27 Apr 1998 11:23:38 -0600
Message-ID: <6i2be9$sd6$1@nnrp1.dejanews.com>

In article <6i1h5v$4qo$1_at_taliesin.netcom.net.uk>, Matthew O'Byrne <Iridium_at_netcomuk.co.uk> wrote:
>
> 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.
>
>

Try this SQL stmt.

Select KeyName From Keys

	where Keys.KID = UsersKeysLinks.KID
 	and (UsersKeysLinks.ID = 10 )

thanks

Abeeda

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 27 1998 - 12:23:38 CDT