How do I use same column in database to display two different condition column?

See more:

MySQL

How do I use same column in database to display two different condition column?

What I have tried:

Hi All

This is my current table:
Database: "QTY"

<pre>Location   Item   Quantity
    A      2.0       4  
    B      2.0       2  
    A      3.0       3  
    C      2.0       5  
    D      3.0       1  
    B      3.0       1

At the present, I can only out individually,
By this sql

Select QTY.Location, QTY.Quantity
FROM QTY
WHERE QTY.item=2.0;

likes:

Table 1:
Location  2.0
   A       4
   B       2
   C       5

Table 2:
Location  3.0
   A       3
   B       1
   D       1

Desire result:

Location   2.0   3.0
    A      4       3  
    B      2       1  
    C      5       0  
    D      0       1  

Could I have any advice from codeprojecter? Thanks..