https://interactivetools.com/forum/forum-search.php?k=user%3Asandimcp Wed, 13 May 2026 12:30:58 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2206832#post2206832 I'd like to take a look at where you got to and see what the next step is going to be.

Did you eventually solve this puzzle? I would love to know what was done. Thanks.
]]> Wed, 15 Sep 2010 10:59:41 -0700 forum-posts.php?postNum=2206832#post2206832 https://interactivetools.com/forum/forum-posts.php?postNum=2198527#post2198527 You're a lifesaver. :)]]> Mon, 03 Aug 2009 15:31:49 -0700 forum-posts.php?postNum=2198527#post2198527 https://interactivetools.com/forum/forum-posts.php?postNum=2198515#post2198515 Mon, 03 Aug 2009 13:47:47 -0700 forum-posts.php?postNum=2198515#post2198515 https://interactivetools.com/forum/forum-posts.php?postNum=2198489#post2198489 ]]> Sat, 01 Aug 2009 22:50:53 -0700 forum-posts.php?postNum=2198489#post2198489 https://interactivetools.com/forum/forum-posts.php?postNum=2198486#post2198486 I'm working with InstantRealty. What if you have three or more related tables that you want to display in the Listings page? I'm trying to do a LeftJoin but it only works with one table joining one table. I need to filter the listings by at least one field in the second table and also by another field in the third table.

Here is what I have so far.

require_once "cmsadmin/lib/viewer_functions.php";

list($residencesRecords, $residencesMetaData) = getRecords(array(
'tableName' => 'residences',
'perPage' => '10',
'orderBy' => 'residences.feature_end_date DESC, residences.listing_date DESC',
'allowSearch' => '0',
'leftJoin' => array(
'agencies' => 'ON (residences.agency_id= agencies.num)',
),
'leftJoin' .=> array(
'agents' => 'ON residences.agent_id= agents.num' ,
),
'where' => 'agents.currstatus=\'Active\' and agencies.currstatus=\'Active\' and residences.listing_type = \'Buy\'and residences.status = \'Active\'',
));
//Plain SQL that achieves the list of properties I want
//select * from irw_residences left join (irw_agents, irw_agencies) on (irw_residences.num=irw_agents.num and irw_residences.num=irw_agencies.num) where irw_agents.currstatus='Active' and irw_agencies.currstatus='Active' and irw_residences.listing_type='Buy' and irw_residences.status='Active'

Waiting to hear. Hope you can help.]]> Sat, 01 Aug 2009 15:45:16 -0700 forum-posts.php?postNum=2198486#post2198486