SQL 如何根据一个表的内容对另一个表进行排序

2025-01-01 02:15:35
推荐回答(3个)
回答1:

select a.* from Product a,Facture b where a.FactureID=b.FactureID order by b.FactureName

回答2:

select * from Product a,Facture b where a.FactureID=b.FactureID order by a.Name

回答3:

select Product.*
from Product a,Facture b
where a.FactureID=b.FactureID
order by b.FactureName