例如:
SELECT
tco. NAME tconame,
tco.ztime tcoztime,
(
SELECT
count(1)
FROM
t_trading_intention
WHERE
pid = tco.id
AND STATUS = 11
) companynum,
tti.ctime ttictime,
tti. STATUS ttistatus,
tti.id id,
tti.cid cid,
tti.cid1 cid1,
tti.pid pid
FROM
t_trading_intention tti
LEFT JOIN t_cargo tco ON tco.id = tti.pid
WHERE
tti. STATUS = 11
AND (tti.cid = 2
OR tti.cid1 = 2)
ORDER BY
tti.ctime DESC
LIMIT 0,
10;
tti.cid = 2 or tti.cid1 = 2 没有加括号时在逻辑上一直有问题,加上括号问题得以解决