<div>
<div class="content wysiwyg-content">
How do I adjust this sql so that it will LEFT OUTER JOIN to GM230 two times, one for each fy:<br />
<br />
SELECT a.GMUDY, a.GMFUND, a.GMDPT, a.GMDIV, a.GMSTAB, a.GMELM1, a.GMELM2, a.GMOBJ,<br />
&nbsp; a.GMFNDS, a.GMDPDS, a.GMDVDS, a.GMSBDS, a.GMSSDS, a.GMELDS, a.GMOBDS, a.GMAC14, a.GMACFM, b.GMYREV, c.GMYREV, b.GMYREV, c.GMYREV FROM HTEDTA.GM200DB a <br />
&nbsp; &nbsp; LEFT OUTER JOIN HTEDTA.GM230 b ON a.GMFUND=b.GMFUND and a.GMDPT=b.GMDPT and a.GMDIV=b.GMDIV <br />
&nbsp; &nbsp; and a.GMSTAB=b.GMSTAB and a.GMSTAS=b.GMSTAS and a.GMELM1=b.GMELM1 and a.GMELM2=b.GMELM2 and a.GMOBJ=b.GMOBJ &nbsp;LEFT OUTER JOIN HTEDTA.GM230 c ON a.GMFUND=c.GMFUND and a.GMDPT=c.GMDPT and a.GMDIV=c.GMDIV &nbsp;and a.GMSTAB=c.GMSTAB and a.GMSTAS=c.GMSTAS and a.GMELM1=c.GMELM1 and a.GMELM2=c.GMELM2 and a.GMOBJ=c.GMOBJ &nbsp;WHERE b.GMFYR = &nbsp;2015 AND c.GMFYR = 2014
</div>
</div>


How do I adjust this sql so that it will LEFT OUTER JOIN to GM230 two times, one for each fy:

SELECT a.GMUDY, a.GMFUND, a.GMDPT, a.GMDIV, a.GMSTAB, a.GMELM1, a.GMELM2, a.GMOBJ,
  a.GMFNDS, a.GMDPDS, a.GMDVDS, a.GMSBDS, a.GMSSDS, a.GMELDS, a.GMOBDS, a.GMAC14, a.GMACFM, b.GMYREV, c.GMYREV, b.GMYREV, c.GMYREV FROM HTEDTA.GM200DB a 
    LEFT OUTER JOIN HTEDTA.GM230 b ON a.GMFUND=b.GMFUND and a.GMDPT=b.GMDPT and a.GMDIV=b.GMDIV 
    and a.GMSTAB=b.GMSTAB and a.GMSTAS=b.GMSTAS and a.GMELM1=b.GMELM1 and a.GMELM2=b.GMELM2 and a.GMOBJ=b.GMOBJ  LEFT OUTER JOIN HTEDTA.GM230 c ON a.GMFUND=c.GMFUND and a.GMDPT=c.GMDPT and a.GMDIV=c.GMDIV  and a.GMSTAB=c.GMSTAB and a.GMSTAS=c.GMSTAS and a.GMELM1=c.GMELM1 and a.GMELM2=c.GMELM2 and a.GMOBJ=c.GMOBJ  WHERE b.GMFYR =  2015 AND c.GMFYR = 2014

adodb sql multi tables

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.

IBM System i

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.