CODEWITHSUNDEEP
oracle-database
A Prad
A Prad

Reputation: 1

Getting Error when creating custom names in Oracle SQL

I have been trying to execute the following query:- 

select * from pc.A,rpc.B from pparam pc, rparam rpc where pc.A=rpc.B and rpc.C=3945;

But I am getting the following error:-

ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:
Error at Line: 70 Column: 42

Please help me with this.

Upvotes: 0

Views: 37

Answers (1)

NzGuy
NzGuy

Reputation: 397

You have given two from statements .

select * from pc.A,rpc.B from pparam pc, rparam rpc where pc.A=rpc.B and rpc.C=3945;

Upvotes: 1

Related Questions