select b.客户姓名 as 买方姓名, c.客户姓名 as 卖方姓名, a.交易时间
from (表1 as a inner join 表2 as b on a.买方id = b.客户id)
inner join 表2 as c on a.卖方id = c.客户id
from (表1 as a inner join 表2 as b on a.买方id = b.客户id)
inner join 表2 as c on a.卖方id = c.客户id
表2:t2 客户 :Gid, 客户姓名:Gname
select (select Gname form t2 where Gid=t.bid) as buyername,(select Gname from t2 where Gid=t.sid) as sellername ,pt from t1 t