ora_rowscn和加入无法一起工作 [英] ora_rowscn and joins not working together

问题描述

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

此查询在oracle 10g中返回无效标识符异常.我是一个初学者，不知道为什么会出现异常.请帮忙.谢谢.

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.

推荐答案

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

这篇关于ora_rowscn和加入无法一起工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！