【SQL大佬看过来】【萌新求助】

查询语句不对吧

你的意思是，查询表里面所有地址相同的人的信息？

select s.* from morder c inner join morder s on c.address=s.address and c.name!= s.name;

类似
mysql> select * from morder; +---------+---------+
| name | address |
+---------+---------+
| lisi | 北京 |
| kiun | 北京 |
| asd | 广州 |
| chenhua | 深圳 |
| king | 深圳 |
+---------+---------+
5 rows in set (0.00 sec)
mysql> select s.* from morder c inner join morder s on c.address=s.address and c.name!= s.name;
+---------+---------+
| name | address |
+---------+---------+
| lisi | 北京 |
| kiun | 北京 |
| chenhua | 深圳 |
| king | 深圳 |
+---------+---------+
4 rows in set (0.00 sec)