duanbi6522 2014-02-19 16:37
浏览 45
已采纳

cakePHP-SQL-在sql中添加来自不同表的值

I am working on a project which requires me to do some querying which I m having a bit of trouble since my sql is a little rusty. There are 3 tables involved in the query :

donors
donations
donation_methods 

I need to run a valid sql statement logically similar to this with the correct syntax :

SELECT  `tel_no` 
  FROM  `donors` as `dnr` 
        LEFT JOIN  `donations` as `dn` 
                   ON  `dnr`.id =  `dn`.donor_id
        LEFT JOIN  `donation_method` as `dm` 
                   ON `dn`.donation_method_id = `dm`.id
  WHERE `dn`.created`+`dm`.recovery_time >= NOW() // here is the problem

Im not entirely sure on how to do it! Any help? Also if this can be done using cake's method (find,etc), in conjunction with the 'conditions' array, that would be great! Thanks

[EDIT] Recovery time is of INT type, whilst created is of type datetime

  • 写回答

2条回答 默认 最新

  • dourang6423 2014-02-19 16:44
    关注

    You should be able to use the DATE_ADD function for this

    WHERE DATE_ADD(dn.created, INTERVAL dn.recovery_time YEAR) >= NOW()
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 调用函数时,无关变量的改变引起函数值的改变
  • ¥15 xy坐标转化为经纬度坐标
  • ¥15 一般三角模糊数的上界值和下届值取中值的多少比较合理?
  • ¥15 关于#python#的问题,请各位专家解答!
  • ¥20 Hbase启动失败,无法启动HMaster
  • ¥15 sqpingboot在父模块已经引入了mybatisplus 在子组件不写版本号还是报错
  • ¥20 Lumerical FDTD solutions 中模型的相对阻抗,有效介电常数和有效磁导率的实部和虚部的数据如何获得?
  • ¥100 sql reporting service 远程smtp服务器配置支持
  • ¥15 ppyoloe_r带角度目标检测,loss_cls没法收敛
  • ¥15 淘宝交易指数如何解读,其关联的数据指标是什么