搜索 |
SELECT
*
FROM
`chengben_biaozhun` AS bzb
JOIN chengben_mingcheng mc ON mc.id = bzb.mingChengID
WHERE
IF (
(
SELECT
count(bzb.addTime)
FROM
`chengben_biaozhun` AS bzb
JOIN chengben_mingcheng mc ON mc.id = bzb.mingChengID
WHERE
bzb.addTime = '2019-05-27'
),
bzb.addTime='2019-05-27',
bzb.addTime='2019-05-28'
)