请使用mybatis表示以下sql语句:SELECT s.id ,partner_id,r.name FROM `sale_order` as s left join res_partner as r on s.partner_id = r.id ;
时间: 2024-03-23 11:37:37 浏览: 27
使用MyBatis的注解方式表示以上SQL语句可以如下:
```java
@Select("SELECT s.id, partner_id, r.name FROM sale_order s LEFT JOIN res_partner r ON s.partner_id = r.id")
List<SaleOrderDTO> selectSaleOrderAndPartner();
```
其中,`SaleOrderDTO`为返回结果对象。如果使用XML方式配置SQL语句,则可以如下编写:
```xml
<select id="selectSaleOrderAndPartner" resultType="SaleOrderDTO">
SELECT s.id, partner_id, r.name FROM sale_order s LEFT JOIN res_partner r ON s.partner_id = r.id
</select>
```
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)