select a.ttc,convert(a.oilgunno,SIGNED) as oilgunno,
a.cardno, a.machineoilno,a.oilno,b.oilname,
DATE_FORMAT(a.takedate, '%Y-%m-%d %H:%i:%s') as takedate
from srs_bm_oilvouch a
LEFT JOIN srs_system_oiltype b ON a.oilno = b.oilno,还有C表还要 左连接和 a 表,应该怎么样,谢谢
a.cardno, a.machineoilno,a.oilno,b.oilname,
DATE_FORMAT(a.takedate, '%Y-%m-%d %H:%i:%s') as takedate
from srs_bm_oilvouch a
LEFT JOIN srs_system_oiltype b ON a.oilno = b.oilno,还有C表还要 左连接和 a 表,应该怎么样,谢谢
解决方案 »
- mysql model index field error错误 在线等 急
- mysql查询占用大量时间引发的问题,急。
- mysql集群上如何创建表?
- ERROR: relation "publisher" does not exist 请大家帮忙看看
- mysql安装目录MySQL\MySQL Server 5.1\data下的query_log是干什么的
- 我想头问一个问题
- 简单的问题:怎么得到数据库中(MSSQL)某个表最后修改的时间?
- 我的mysql管理员权限有问题啊,为什么只有root用户可以使用
- 急!jsp+mysql,急寻blob输出方法!!!
- 求助 给个数据库查询源码
- MySQL的触发器是没有new这个关键字吗??
- 三表关联查询sql语句
a.cardno, a.machineoilno,a.oilno,b.oilname,
DATE_FORMAT(a.takedate, '%Y-%m-%d %H:%i:%s') as takedate
from srs_bm_oilvouch a
LEFT JOIN srs_system_oiltype b ON a.oilno = b.oilno
LEFT JOIN C表 c ON a.XXX = c.XXX
a.cardno, a.machineoilno,a.oilno,b.oilname,
DATE_FORMAT(a.takedate, '%Y-%m-%d %H:%i:%s') as takedate
from srs_bm_oilvouch a
LEFT JOIN srs_system_oiltype b ON a.oilno = b.oilno,
LEFT JOIN 第三个表 c ON a.oilno = c.oilno
a.cardno, a.machineoilno,a.oilno,b.oilname,
DATE_FORMAT(a.takedate, '%Y-%m-%d %H:%i:%s') as takedate
from srs_bm_oilvouch a
LEFT JOIN srs_system_oiltype b ON a.oilno = b.oilno,
LEFT JOIN c on a.oilno=c.oilno