日期:2014-05-17 浏览次数:20674 次
select part, (select SUPPLIER_NAME from supplier where supp = t.supp1) as supp1, (select SUPPLIER_NAME from supplier where supp = t.supp2) as supp2, (select SUPPLIER_NAME from supplier where supp = t.supp3) as supp3 from part t
SQL code?12345select part, (select SUPPLIER_NAME from supplier where supp = t.supp1) as supp1, (select SUPPLIER_NAME from supplier where supp = t.supp2) as supp2, (selec……