把两张桌子连起来

我有两个表

表1 类别

Id    name      img   
1   appliances   
2   books

表2产品

ID  name des  price  cataegory sub  img
1  TV    lcd  125     1        tv

我正试图加入表2中类别中的两个表。我将从表1中获得名称

它将显示为

ID  name des  price  cataegory sub  img
1  TV    lcd  125  appliances    tv  

这是我的代码

    $sql = "SELECT p.id, 
                   p.name,
                   p.description, 
                   p.price,
                   c.name,
                   p.sub
            FROM products p
            JOIN category c on products p = c.id
            ORDER by p.id
            ";
    if($query =  mysql_query($sql) or die())
    {
        while($result = mysql_fetch_assoc($query))
        {   echo "<tr id='id'>";
            //echo "<td>".$result['img']."</td>";
            echo "<td>".$result['name']."</td>";
            echo "<td>".$result['description']."</td>";
            echo "<td>".$result['price']."</td>";
            echo "<td>".$result['category']."</td>";
            echo "<td>".$result['sub']."</td>";
            echo "</tr>";
        }
    }       ";