寻找薛定谔的猫

导航

 
(SELECT * FROM `idents` where PhotoID = 'badc74d6-58bd-4e46-9a48-aefb3487a61d' AND Selected = 'Yes' ORDER BY IdentTime desc LIMIT 1)
UNION ALL
(SELECT * FROM `idents` where PhotoID = 'badc74d6-58bd-4e46-9a48-aefb3487a61d' AND Author = 'devtest'  ORDER BY IdentTime desc limit 1)

两边的语句加上括号就可以了

posted on 2018-11-02 17:33  teagueli  阅读(2541)  评论(0编辑  收藏  举报