How To Use Join With Condition?

1.	How To Use Join With Condition?
Answer» $queryObj = Services Model_Org::QUERY() ->RELATED('org') ->related('profile_image')->related( ARRAY( 'comments' => array( 'where' => array( array('visible' , '=' , '0') ) ) )) ->where ('rating','!=', 'null') ->order_by ('rating','desc') ->get (); $queryObj = Services Model_Org::query() ->related('org') ->related('profile_image')->related( array( 'comments' => array( 'where' => array( array('visible' , '=' , '0') ) ) )) ->where ('rating','!=', 'null') ->order_by ('rating','desc') ->get ();

Answer»

$queryObj = Services Model_Org::QUERY()

->RELATED('org')

->related('profile_image')->related( ARRAY( 'comments' => array( 'where' => array( array('visible' , '=' , '0') )

) ))

->where ('rating','!=', 'null')

->order_by ('rating','desc')

->get ();

$queryObj = Services Model_Org::query()

->related('org')

->related('profile_image')->related( array( 'comments' => array( 'where' => array( array('visible' , '=' , '0') )

) ))

->where ('rating','!=', 'null')

->order_by ('rating','desc')

->get ();

Discussion