mysql同时查三个表怎么弄啊写详细点，谢谢

这三张表
create table student(ids int identity(1,1) primary key,names varchar(20), sexs varchar(20),passwords varchar(20));

create table guanliyuan(ids int auto_increment primary key,nameg varchar(30),sexg varchar(10),passwordg varchar(20));

create table teacher(ids int auto_increment primary key,namet varchar(30),sext varchar(10),passwordt varchar(20));

最新回答

__宫雅沫つ

2024-11-07 00:06:16

select * from student as s,guanliyuan as g,teacher as t
where s.ids = g.ids and s.ids = t.ids
条件可以根据你的需要来查询。

追问