Need help with Oracle error .. grr

ok .. this is the query:
SELECT ATTRIBUTES.NAME, COLLECTIONS.NAME
FROM ATTRIBUTES INNER JOIN COLLECTIONS ON ATTRIBUTES.NAME = COLLECTIONS.NAME
WHERE COLLECTIONS.NAME) Is Null

this is the error:
ORA-00933: SQL command not properly ended

This comand works fine if i link the tables through access and run it... it also seems to check out syntactically just fine. Is there something in oracle that makes it interpret inner joins differently?
this sucks.. i've searched everywhere and cant find any answers.. please tell me one of u here is an oracle god https://www.sharkyforums.com/images/.../2005/06/5.gif


------------------
-Fiddler

Did you try posting to www.deja.com?

I am assuming you mistyped, but you only have one ')' in your statement.

------------------
Blueskies Blackdeath

Best thing to do is stop using Oracle, start using DB2 https://www.sharkyforums.com/images/.../2005/06/5.gif

------------------
DHAHL3seasons GP:73 G:121 A:55 Pts:176 GWG:12 +/-:184
UWSWA1season GP:9 G:12 A:8 Pts:20 GWG:3 +/-:-3

uwcdc.com or namgor.com

Yes i did mistype that .. in the actual statement there's no extra ")" and i cant switch the platforms https://www.sharkyforums.com/images/.../2005/06/5.gif


------------------
-Fiddler

It looks good to me. It even runs in TSQL. sorry I dont have an oracle test site or I would try it out there.

------------------

MMMMMMMMMM...... BAR-B-Q
-- Homer Simpson