title: Combining two queries without using Union
body: <p>I have two queries and want to combine these two queries without using "<code>UNION</code>" </p>
  
  <p>for example</p>
  
  <p>query 1:</p>
  
  <pre><code>Select
      T1.Field1,T1.Field2,T2.Field3
  from
      T1, T2, T3
  where T1.XYZ = T2.XYZ AND T1.STATUS = 'S' AND T1.XYZ = T3.XYZ AND T3.ABC = 'Y';
  </code></pre>
  
  <p>Result : 10 rows</p>
  
  <p>query 2:</p>
  
  <pre><code>Select
      T1.Field1,T1.Field2,T2.Field3
  from
      T1, T2, T4
  where
      T1.XYZ = T2.XYZ AND T1.STATUS = 'W' AND T1.XYZ = T4.XYZ AND T4.ABC = 'Y';
  </code></pre>
  
  <p>Result : 5 rows.</p>
  
  <p>Is there a way to combine query 1 and query 2 into single without using "<code>UNION</code>" and get the result as 15 (10+5).</p>
  
  <p>Thanks in advance</p>