I have listed the 2 tables and the sql query which is causing the ora 0904 error. invalid identifier. pls let me know what's wrong on it. I'm using oracle 10g
Create table entry list (
Parent node ID varchar2 (10) not null,
Entry name varchar2 (50) not null,
PRIMARYKEY number CONSTRAINT pk_ entry list primary key not null,
CONSTRAINT unq_ entry list unique (parent node ID));
Create table access condition (
Access condition ID varchar2 (10) not null,
Resource IDentification varchar2 (10) not null,
Resource classification NUMBER not null,
CONSTRAINT pk_ access conditional chart primary key (access condition ID));
SELECT access condition.* FROM access conditional WHERE entry list.Entry name = '1' AND entry list.PRIMARYKEY = 'userSR3'
the reported error is ORA-00904: "entry list.PRIMARYKEY" is invalid identifier.