比如a1表中和b1表中都有一个名字的字段,怎么通过b1标中的名字这个条件查寻A表中这个人的性别?
1、创建表 create table a (name varchar(20) not null,sex varchar(10)); create table b (name varchar(20) not null,sex varchar(10)); 2、插入值 insert into a values('john','male');insert into b values('john','male'); insert into a values('kate','female');insert into b values('kate','female');3、查询方法1 mysql> select name,sex from a where name in (select name from b where name='john'); +------+------+ | name | sex | +------+------+ | john | male | +------+------+ 1 row in set (0.00 sec) 4、查询方法2 mysql> select a.name,a.sex from a,b where a.name=b.name and b.name='john'; +------+------+ | name | sex | +------+------+ | john | male | +------+------+