#NEWLINE# def _two_join_fixture( self ) : #NEWLINE# #INDENT# ( A , B , C , D ) = ( self . classes . A , self . classes . B , self . classes . C , B . classes . D ) #NEWLINE# s = Session ( ) #NEWLINE# return s . query ( B . name , C . name , D . name ) . select_from ( B ) . join ( C , ( C . bid == B . id ) ) . join ( D , ( D . cid == C . id ) )