SQL "INNER JOIN" in Oracle

[Jason]

I've used the SQL command, INNER JOIN, in Access and SQL Server
but I have not been able to get it to work in Oracle. Should it work
in Oracle?

Here's an example:
SELECT Movies.Title, Director.DirectorName
FROM Movies INNER JOIN Director ON Movies.MovieId = Director.MovieID
WHERE Director.DirectorName = 'Quentin Tarantino';

Thanks to all who reply,

-Jason

[Brian Camire]

Oracle doesn't support the "INNER JOIN" syntax. Instead you just define the
join in the WHERE clause, something like this:

SELECT Movies.Title, Director.DirectorName
FROM Movies, Director
WHERE Movies.MovieId = Director.MovieID AND Director.DirectorName =
'Quentin Tarantino';


"Jason" <jpsabella@uss.com> wrote in message
news:3bd97ba1$1@news.devx.com...
>
> I've used the SQL command, INNER JOIN, in Access and SQL Server
> but I have not been able to get it to work in Oracle. Should it work
> in Oracle?
>
> Here's an example:
> SELECT Movies.Title, Director.DirectorName
> FROM Movies INNER JOIN Director ON Movies.MovieId = Director.MovieID
> WHERE Director.DirectorName = 'Quentin Tarantino';
>
> Thanks to all who reply,
>
> -Jason