SELECT 下货名,肉名 FROM (SELECT A.NAME 下货名, A.weight,(A.weight*c.p_weight/125) 下货出品重量, B.DJ,(A.weight*c.p_weight/125)*B.DJ 下货金额 FROM m AS A, m_up AS B, UPUP AS C where A.name = B.name AND A.ID = 2)C, (SELECT A.name 肉名, A.weight,(A.weight*c.p_weight/125) 肉出品重量, (A.weight*c.p_weight/125)*B.DJ 肉金额 FROM m AS A, m_up AS B, UPUP AS C where A.name = B.name AND A.ID = 1)D |