https://www.webmaster-forums.net/crss/node/1035543 en https://www.webmaster-forums.net/web-database-development/sql-and-adding-another-table#comment-1205426 <p>Just reformatting your SQL for easier reading by myself and others.<br /> <div class="codeblock"><code>&lt;strong&gt;SELECT&lt;/strong&gt; <br />&nbsp;&nbsp; tblRegistrationModifier.OrganisationID,<br />&nbsp;&nbsp; tblOrganisation.Organisation,<br />&nbsp;&nbsp; tblRegistrationModifier.RegistrationModifier,<br />&nbsp;&nbsp; tblRegistrationModifier.UsageMax,<br />&nbsp;&nbsp; tblRegistrationModifier.UsageCurrent<br />&lt;strong&gt;FROM&lt;/strong&gt; <br />&nbsp;&nbsp; tblRegistrationModifier<br />&lt;strong&gt;INNER JOIN&lt;/strong&gt; <br />&nbsp;&nbsp; tblOrganisation &lt;strong&gt;ON&lt;/strong&gt; tblRegistrationModifier.OrganisationID = tblOrganisation.OrganisationID<br />&lt;strong&gt;WHERE&lt;/strong&gt; <br />&nbsp;&nbsp; tblRegistrationModifier.FrameworkID = 2 &lt;strong&gt;AND&lt;/strong&gt; <br />&nbsp;&nbsp; tblRegistrationModifier.OrganisationID &lt;strong&gt;NOT IN &lt;/strong&gt;<br />&nbsp;&nbsp; (<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;strong&gt;SELECT&lt;/strong&gt; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;strong&gt;FROM &lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;strong&gt;WHERE&lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID = 11939 &lt;strong&gt;OR&lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID = 11792 &lt;strong&gt;OR&lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID = 11783 &lt;strong&gt;OR&lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID = 11489 &lt;strong&gt;OR&lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID = 11881 &lt;strong&gt;OR&lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID = 11465 &lt;strong&gt;OR&lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID = 11852 &lt;strong&gt;OR&lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID = 11749 &lt;strong&gt;OR&lt;/strong&gt;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tblRegistrationModifier.OrganisationID = 11790<br />&nbsp;&nbsp; )</code></div>'<br /> -Greg</p> Mon, 07 Aug 2006 19:55:44 +0000 Greg K comment 1205426 at https://www.webmaster-forums.net