<?xml version="1.0" encoding="UTF-8"?>    <rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
      <channel>
        <title>Desperately need help with Join</title>
        <link>https://interactivetools.com/forum/forum-posts.php?Desperately-need-help-with-Join-81088</link>
        <description></description>
        <pubDate>Tue, 14 Jul 2026 21:27:37 -0700</pubDate>
        <language>en-us</language>
        <atom:link href="https://interactivetools.com/forum/forum-posts.php?rss=1&amp;Desperately-need-help-with-Join-81088" rel="self" type="application/rss+xml" />

                <item>
          <title>Desperately need help with Join</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241038#post2241038</link>
          <description><![CDATA[<p>Works great, Thanks so very much</p>]]></description>
          <pubDate>Tue, 08 Aug 2017 18:30:19 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241038#post2241038</guid>
        </item>
                <item>
          <title>Desperately need help with Join</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241037#post2241037</link>
          <description><![CDATA[<p>Hi dlsweb, </p>
<p>This isn't an officially supported option, but it's not going away so you can try it out.  Try this: </p>
<p><code>// load records from 'accounts'<br /> list($accountsRecords, $accountsMetaData) = getRecords(array(<br />  'tableName' =&gt; 'accounts',<br />  'perPage' =&gt; '25', <br />  'loadUploads' =&gt; false,<br />  'allowSearch' =&gt; false,<br />  'leftJoin' =&gt; array( // Note: leftJoins require you to use fully qualified fieldnames in WHERE and ORDER BY, such as tablename.fieldname<br />    'festivals' =&gt; 'ON accounts.num = festivals.createdByUserNum',<br />  ),<br /> ));</code></p>
<p>Let me know if that works for you.</p>
<p>An alternative approach is just to load the festivals and or account separately as in this post: <br /><a href="https://www.interactivetools.com/forum/forum-posts.php?postNum=2240982#post2240982" rel="nofollow">https://www.interactivetools.com/forum/forum-posts.php?postNum=2240982#post2240982</a></p>

]]></description>
          <pubDate>Tue, 08 Aug 2017 16:53:59 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241037#post2241037</guid>
        </item>
                <item>
          <title>Desperately need help with Join</title>
          <link>https://interactivetools.com/forum/forum-posts.php?postNum=2241026#post2241026</link>
          <description><![CDATA[<p>I am lost using Join<br />Can someone please tell me how to do.</p>
<p>From accounts table, I want to show 'fullname' and 'email' and 'state'<br />and from festivals table, 'title' and 'begin_date'</p>
<p>accounts.num = festivals.createdByUserNum</p>
<p><br /> // load records from 'accounts'<br /> list($accountsRecords, $accountsMetaData) = getRecords(array(<br /> 'tableName' =&gt; 'accounts',<br /> 'perPage' =&gt; '25', <br /> 'loadUploads' =&gt; false,<br /> 'allowSearch' =&gt; false,<br /> ));</p>
<p>something like?<br />LEFT JOIN festivals ON accounts.num = festivals.createdByUserNum;</p>
<p><br />html<br />&lt;?php echo htmlencode($record['fullname']) ?&gt;&lt;br/&gt;<br />&lt;?php echo htmlencode($record['email']) ?&gt;&lt;br/&gt;<br />&lt;?php echo htmlencode($record['state']) ?&gt;&lt;br/&gt;<br />??<br />&lt;?php echo htmlencode($record['festivals.title']) ?&gt;&lt;br&gt;<br />&lt;?php echo date("M j, Y", strtotime($record['festivals.begin_date'])) ?&gt;&lt;br&gt;</p>]]></description>
          <pubDate>Mon, 07 Aug 2017 12:50:03 -0700</pubDate>
          <guid isPermaLink="true">forum-posts.php?postNum=2241026#post2241026</guid>
        </item>
              </channel>
    </rss>
  