用pyodbc联接mdb表 [英] JOINing mdb tables with pyodbc

问题描述

我尝试在python(pyodbc)中以这种方式JOIN两个MS访问表:

I try to JOIN two MS access tables this way in python (pyodbc):

query = "SELECT Karta.id FROM Karta JOIN zaznam ON (Karta.id=zaznam.karta)"
cursor.execute(query) 

但是我遇到一个错误:

pyodbc.ProgrammingError 42000  microsoft access driver syntax error in form clause -3506 SqlExecDirectW

我在做什么错了?

推荐答案

您需要在FROM子句中指定联接的类型(INNER，LEFT OUTER，RIGHT OUTER).使用的联接类型取决于您希望结果包含的内容，我猜您希望使用INNER JOIN.可以在这里.

You need to specify the type of join (INNER, LEFT OUTER, RIGHT OUTER) in the FROM clause. The type of join used depends on what you want the results to contain, I'm guessing you want an INNER JOIN. A reference for the join types available in Access can be found here.

假设INNER JOIN

Sample code assuming INNER JOIN

query = "SELECT Karta.id FROM Karta INNER JOIN zaznam ON (Karta.id=zaznam.karta)"
cursor.execute(query) 

这篇关于用pyodbc联接mdb表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！