mysql - can join query do the same tasks to one query
    Table A
    Table B
    Tabls C1, C2 .... Cn : title field
    
    relationship C INNER JOIN B LEFT JOIN A
    
    query 
    SELECT C1.title FORM C1 
    INNER JOIN B on C1.c_id = B.c_id
    LEFT JOIN A on B.b_id = A.b_id

and will have n above query 

Can do it with one query ?
mysql - can join query do the same tasks to one query
===

    Table A
    Table B
    Tabls C1, C2 .... Cn : title field
    
    relationship C INNER JOIN B LEFT JOIN A
    
    query 
    SELECT C1.title FORM C1 
    INNER JOIN B on C1.c_id = B.c_id
    LEFT JOIN A on B.b_id = A.b_id

and will have n above query 

Can do it with one query ?