有如下记录
mysql> select * from user where city='beijing' or skill='pugong';
+------+---------+---------+--------+----------+
| uid | city | company | skill | zhengshu |
+------+---------+---------+--------+----------+
| 1 | beijing | a | baoan | benke |
| 1 | nanjing | b | pugong | benke |
| 2 | shanxi | b | pugong | benke |
+------+---------+---------+--------+----------+我想得到在北京工作过的又有pugong技能的人的uid。也就是uid=1。这样的查询能不能得到??
mysql> select * from user where city='beijing' or skill='pugong';
+------+---------+---------+--------+----------+
| uid | city | company | skill | zhengshu |
+------+---------+---------+--------+----------+
| 1 | beijing | a | baoan | benke |
| 1 | nanjing | b | pugong | benke |
| 2 | shanxi | b | pugong | benke |
+------+---------+---------+--------+----------+我想得到在北京工作过的又有pugong技能的人的uid。也就是uid=1。这样的查询能不能得到??
from user a
where city='beijing'
and exists (select 1 from user where skill='pugong' and uid=a.uid);
from user a inner join user b on a.uid=b.uid
where a.city='beijing' and b.skill='pugong'