阅读背景:

内部联接与子查询以从数据透视表中筛选记录

来源:互联网 

This is my query

这是我的疑问

 SELECT t.*
 FROM `User` `t`
 INNER JOIN (
     SELECT cv.relatedId
     FROM CustomValue cv
     WHERE (cv.customFieldId=11 AND (cv.fieldValue like '%dsasda%')) OR (cv.customFieldId=15 AND (cv.fieldValue like '%1%'))
     GROUP BY cv.relatedId
     HAVING count(*) >= 1
) tblcv  ON  tblcv.relatedId = t.id
 SELECT t.*
 FROM `



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: