Dear all,
I am getting some error during creation of views and the statement that I used to create is given,tell me what is the problem in the statement :
Code:
Create view Banktransact_view as
SELECT C.Emp_Id, C.Supplier, C.Account_No, C.Voch_N,C.Voch_Date,
C.ExpMonth, C.BillingMonth,C.Amount, C.Notes, b.grade
FROM CASH_tras C, billinghr b
where CASH_tras.emp_id=billinghr.emp_id;
And occur some following error :
Error: ORA-00904: "BILLINGHR"."EMP_ID": invalid identifier
00904. 00000 - "%s: invalid identifier"
Please tell me what would be the solution of this error.
Thanks.
Bookmarks