Need help with Oracle error .. grr

[Fiddler]

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 http://www.sharkyforums.com/ubb/smile.gif


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

[alienrash]

Did you try posting to www.deja.com? (http://www.deja.com?)

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

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

[namgor]

Best thing to do is stop using Oracle, start using DB2 http://www.sharkyforums.com/ubb/smile.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 (http://www.uwcdc.com) or namgor.com (http://www.namgor.com)

[Fiddler]

Yes i did mistype that .. in the actual statement there's no extra ")" and i cant switch the platforms http://www.sharkyforums.com/ubb/smile.gif


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

[krack_it_up]

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