多表联合查询的有关问题 sap SQL查询

多表联合查询的问题 sap SQL查询
a表                            b表                              c表
----------------------------------

a1  a2                        b1 b2(a2)                     c1(b1) c3
--------------------------------------
1   2                         3  2                           3      2
                                                             3      5 
------------------------------------- 
                        
4   5                         6  7                           6     7
--------------------------------------

8   9                         10   9                         10     11
                              12   9
------------------------------------


现要查所有的信息 select a1 a2 b1 b2 c1 c3 from a 
                                         inner join b  on a1=b2
                                         inner join c  on c1=b1
                                         where a1= 2 and b1=3 


                           select a1 a2 b1 b2 c1 c3 from a