lokewang
2017-08-31 10:21python flask 框架多表连接查询
sql语句是这样的,不熟悉SQLAlchemy 不知道该怎么写,求大神帮助
SELECT A.project_id,A.creator,A.ip,B.auto_id,B.argument,B.status,B.reportlink,B.taskid
FROM (
SELECT project_id,creator,ip
FROM application
WHERE project_id IN (25696)
)
A
LEFT OUTER JOIN
auto_test
B ON A.project_id = B.project_id;
- 点赞
- 回答
- 收藏
- 复制链接分享
1条回答
为你推荐
- python flask 框架多表连接查询
- flask
- python
- sql
- 框架
- 1个回答