<p>Hello,</p>
<p> </p>
<p>I need a little help with a query.</p>
<p>I have a 2 views and a select:</p>
<p> </p>
<div>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">testCTE AS</span></span></p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">(</span></span></p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">select loc, parent, lochierarchyid, locationid</span></span></p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">from lochierarchy </span></span></p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">where loc=(select loc from workorder where workorder.wonum='</span></span><span style="font-family:arial, sans-serif;">44325333rfsrrhyvf'</span><span style="font-size:10.5pt;font-family:arial, sans-serif;">) and locationid=(select locationid from workorder where wonum='44325333rfsrrhyvf')</span></p>
<p> </p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">UNION ALL</span></span></p>
<p> </p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">select lochierarchy.loc, lochierarchy.parent, lochierarchy.lochierarchyid, lochierarchy.locationid, </span></span></p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">from lochierarchy </span></span></p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">join testCTE on lochierarchy.loc = testCTE.parent where lochierarchy.locationid='INTERNATIONAL'</span></span></p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">)</span></span></p>
<p> </p>
<p><span style="font-family:arial, sans-serif;"><span style="font-size:10.5pt;">/* Another view here TEST2VIEW */</span></span></p>
<p> </p>
<div>SELECT (select distinct l.description from testCTE t1</div>
<div>left outer JOIN testCTE t2 on t1.parent=t2.loc left outer join </div>
<div> locations l on l.loc=t1.loc</div>
<div>and l.locationid=t1.locationid</div>
<div> </div>
<div> where l.FIELD='YES') as Community, /* other fields */ from <span style="font-family:arial, sans-serif;">TEST2VIEW where </span><span style="font-family:arial, sans-serif;">TEST2VIEW.wonum=</span><span style="font-family:arial, sans-serif;">'44325333rfsrrhyvf'</span></div>
<div> </div>
<div> </div>
<div><span style="font-family:arial, sans-serif;">I know that i can define a parameter and connect it to </span><span style="font-family:arial, sans-serif;"> </span><span style="font-family:arial, sans-serif;">TEST2VIEW.wonum but if I try to give the same parameter in the first view it doesn't work. Can someone please help me?</span></div>
</div>
<p> </p>
