将旧的Oracle外连接语法(+)转换为JOIN [英] Convert old Oracle outer join syntax (+) to JOIN

问题描述

我有一个查询是使用旧的(+)语法为Oracle编写的，现在我想将其转换为Access SQL.

I have a query that was written for Oracle using the old (+) syntax and now I want to convert it to Access SQL.

这是我的查询:

select BOOKCODE.BOOKCODEID,BOOKCODE.BOOKCODENAME 
from Application_bookcode, BookCode 
where BOOKCODE.BOOKCODEID (+) = HMISUnitTest.APPLICATION_BOOKCODE.BOOKCODEID 
  and HMISUnitTest.APPLICATION_BOOKCODE.ApplicationId = 7

Access SQL中的等效项是什么?

What is the equivalent in Access SQL?

推荐答案

如果我记得旧的Oracle外连接语法(并且已经很长时间了)，则Access中的相应查询应为

If I remember the old Oracle outer join syntax (and it's been a long time), the corresponding query in Access should be

SELECT 
    BOOKCODE.BOOKCODEID,
    BOOKCODE.BOOKCODENAME 
FROM 
    Application_bookcode
    LEFT JOIN
    BookCode 
        ON BOOKCODE.BOOKCODEID = APPLICATION_BOOKCODE.BOOKCODEID 
WHERE
    APPLICATION_BOOKCODE.ApplicationId = 7

这篇关于将旧的Oracle外连接语法(+)转换为JOIN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！