mysql ²éѯÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÓÐÈçϼǼ
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¡£ÕâÑùµÄ²éѯÄܲ»Äܵõ½£¿£¿

---

»òÕß

SQL code:
select distinct a.uid
from user a inner join user b on a.uid=b.uid
where a.city='beijing' and b.skill='pugong'