如果表具有相同的列名，如何仅在左连接中打印列名称

 SELECT A.status, B.status, C.status
 FROM A
 LEFT JOIN B ON A.id = B.a_id
 LEFT JOIN C ON A.id = c.a_id

Output of my query:

status status status
--------------------
1       1     NULL
0      NULL    1
1       0      NULL
0      NULL     0

I do not want null values.

I want output like this

 Id(A table primary key ) status
 --------------------------------
 1                           1
 2                           0
 3                           1    
 4                           0

SELECT A.status as status FROM A left JOIN B ON A.id = B.a_id left JOIN c ON A.id = c.a_id

Try this way

SELECT A.status 'A-Status', B.status 'B-Status',c.status 'C-Status'
 FROM A
 left JOIN B ON A.id = B.a_id
 left JOIN c ON A.id = c.a_id

SELECT A.status, 
    (CASE 
        WHEN ( A.status =1 ) THEN 
            B.status ELSE c.status 
        END 
    ) 
    AS ss 
    FROM A 
    LEFT JOIN B ON A.id = B.a_id 
    LEFT JOIN c ON A.id = c.a_id