ODBC Driver for Odoo

Build 24.0.8963

JOIN Queries

The CData ODBC Driver for Odoo supports standard SQL joins like the following examples.

Inner Join

An inner join selects only rows from both tables that match the join condition:

SELECT res_users.name AS login, res_partner.name AS contact, res_partner.company_name AS company FROM res_users INNER JOIN res_partner ON res_users.partner_id = res_partner.id

Left Join

A left join selects all rows in the FROM table and only matching rows in the JOIN table:

SELECT res_partner.name AS contact, res_users.login AS username FROM res_partner LEFT JOIN res_users ON res_partner.id = res_users.partner_id

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963