您可以尝试使用内部联接
select a.name as buyer_name, a.surname as buyer_surname, c.comment
e.name as seller_name, e.surname as seller_surname
from User as a
Inner Join Auction as b on b.id_buyer = a.id_user
inner join Realization as c on c.id_voice = b.id_voice
inner join Offer as d on d.id_offer = b.id_offer
inner join User as e on d.id_seller = e.id_user;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句