SELECT three.userindcap FROM twoindex CROSS JOIN three WHERE (three.userid = 'police') AND (twoindex.reorder = '3') AND (twoindex.userindex IN (SELECT three.userindex FROM three))
select a.usercap from a,b where b.userno='' and a.user=b.user
不对呀,这样的话userno不同的也被查出来了,不相信可以试一下。
select a.usercap distinct from a,b where b.userno='' and a.user=b.user
select a.usercap from a, b where q.a.user=b.user and b.userno=值
select tab_a.usercap from a tab_a,b tab_b where tab_a.user = tab_b.user and tab_b.userno = ?
FROM twoindex CROSS JOIN
three
WHERE (three.userid = 'police') AND (twoindex.reorder = '3') AND
(twoindex.userindex IN
(SELECT three.userindex
FROM three))