sql pivot

 SELECT *
 FROM   ( SELECT    s.NAME AS vendorName ,
                    p.NAME AS productName ,
                    ptp.UNIT_PRICE
          FROM      dbo.SUPPLIER s ,
                    dbo.PRICE_TABLE pt ,
                    dbo.PRICE_TABLE_PRODUCT ptp
                    LEFT JOIN dbo.PRODUCT p ON ptp.PRODUCT = p.PRODUCT_ID
          WHERE     pt.PRICE_TABLE_ID = ptp.PRICE_TABLE
                    AND s.SUPPLIER_ID = pt.SUPPLIER
        ) p PIVOT
        ( MAX(p.UNIT_PRICE) FOR p.productName IN ( 牛肉, 鱼肉 ) )
        AS pivotTable