丈夫 — 妻子
SQL
create table husband(
hid int primary key,
hname varchar(20)
);
create table wife(
wid int primary key,
wname varchar(20)
);
-- 张三的老婆是谁
select concat(h.hname,' love ',w.wname) 洞房 from husband h inner join wife w
on h.hid = w.wid
where h.hname = '张三';
结果