mysql联立两个表_mysql同时查询两个表
展开全部
我随便搞了点数据,能达到你的效果32313133353236313431303231363533e4b893e5b19e31333332616530
create table vote
(voteId int,
subject varchar(20));
create table item
(itemId int,
vid int,
itemName varchar(20));
insert into vote values (1,'您喜欢的明星');
insert into vote values (2,'您喜欢的运动');
insert into item values (1,1,'成龙');
insert into item values (2,1,'周润发');
insert into item values (3,1,'陈冠希');
insert into item values (4,2,'足球');
insert into item values (5,2,'篮球');
insert into item values (6,2,'游泳');
select a.s from
(select 1 id,voteId,subject s from vote
union all
select 2 id,vid,itemname s from item) a
order by voteid,id