ora_rowscn and joins not working together

Question

SELECT "Rental".*, "Rental".ora_rowscn as TimeStamp FROM "Rental" 
       inner join "UserBranch" on "UserBranch"."fkBranchId" = "Rental"."fkBranchId"
       WHERE "Rental"."IsDeleted"='N' ;

This query returns me invalid identifier exception in oracle 10g. I'm a beginner and don't know why the exception is coming. please help. Thank you.

Answer 1

Select "Rental".* ,"UserBranch"."fkBranchId", "Rental".ora_rowscn as TimeStamp from "Rental","UserBranch"
        where "UserBranch"."fkBranchId" = "Rental"."fkBranchId"
     and "Rental"."IsDeleted"='N';

without joins it works perfectly for me

Answer 2

Please try to get your values with the below query :

SELECT Rental.*, Rental.ora_rowscn as TimeStamp FROM Rental 
inner join UserBranch on UserBranch.fkBranchId = Rental.fkBranchId 
WHERE Rental.IsDeleted='N' ;