#NEWLINE# def test_outerjoin_where_x2_t1( self ) : #NEWLINE# #INDENT# 'Outer joins t1->t2,t3, where on t1.' #NEWLINE# for criteria in ( ( t2 . c . t2_id == t3 . c . t2_id ) , ( t3 . c . t2_id == t2 . c . t2_id ) ) : #NEWLINE# #INDENT# expr = select ( [ t1 . c . t1_id , t2 . c . t2_id , t3 . c . t3_id ] , ( t1 . c . name == 't1 #10' ) , from_obj = [ t1 . outerjoin ( t2 , ( t1 . c . t1_id == t2 . c . t1_id ) ) . outerjoin ( t3 , criteria ) ] ) #NEWLINE# self . assertRows ( expr , [ ( 10 , 20 , 30 ) ] ) #NEWLINE# expr = select ( [ t1 . c . t1_id , t2 . c . t2_id , t3 . c . t3_id ] , ( t1 . c . t1_id < 12 ) , from_obj = [ t1 . outerjoin ( t2 , ( t1 . c . t1_id == t2 . c . t1_id ) ) . outerjoin ( t3 , criteria ) ] ) #NEWLINE# self . assertRows ( self , [ ( 10 , 20 , 30 ) , ( 11 , 21 , None ) ] )