OraFAQ Forum: SQL & PL/SQL » Problem with Inner Join (converting SQL from Access)

Home » SQL & PL/SQL » SQL & PL/SQL » Problem with Inner Join (converting SQL from Access)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with Inner Join (converting SQL from Access) [message #1940]

Wed, 12 June 2002 05:27

Chris Harrington
Messages: 1
Registered: June 2002

Junior Member

I'm trying to convert SQL statements from MS Access to Oracle. Right now, I'm running into this error message: "Query cannot be updated because the FROM clause is not a single simple table name."

Here is the original statement in Access:

SELECT ENTRY.* FROM ENTRY INNER JOIN LOGIN ON ENTRY.[[Entry #]] = LOGIN.SELECTED_WITHDRAWAL WHERE (((LOGIN.USER_ID)=[[forms]]![[ezftz login screen]].[[user id]]));

Here was my attempt in Oracle:

"SELECT ENTRY.* FROM ENTRY, LOGIN WHERE ENTRY.Entry_NO='" & Entry_NO & "' AND LOGIN.USER_ID= '" & UserID & "'"

The problem is trying to convert that INNER JOIN. Help, please?

Chris

Report message to a moderator

Previous Topic:	Re: problem with for loop
Next Topic:	CLOB+test on NULL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:33:13 CDT 2024