title: Oracle SQL left outer join on two subqueries
body: <p>I'm working in an oracle database and receive the following error: </p>
  
  <p>Microsoft OLE DB Provider for SQL Server : Invalid object name</p>
  
  <p>I've also tried joining in the where clause, but I also receive </p>
  
  <p>Here's the query:</p>
  
  <pre><code>select UE_invoice.InvoiceNo,
         UE_invoice.DueDate,
         UE_payment.CheckNo,
         UE_payment.Amount
  
  from
  
  (select tblTransaction.InvoiceNo,
         tblTransaction.DueDate
    from tblTransaction,
         tblTransactionType
   where
   tblTransaction.Type = tblTransactionType.TransactionType
   and
   tblTransaction.Date &gt;= '01/01/2018'
   and
   tblTransaction.Type = -88) UE_invoice,
  
  (select tblTransaction.InvoiceNo,
         tblTransaction.DueDate,
         tblTransaction.CheckNo,
         tblTransaction.Amount
  from tblTransaction,
       tblTransactionType
   where
   tblTransaction.Type = tblTransactionType.TransactionType
   and
   tblTransaction.Date &gt;= '01/01/2018'
   and
   tblTransaction.Type = -86) UE_payment
  
  Left outer join UE_invoice on UE_invoice.InvoiceNo = UE_payment.InvoiceNo
  </code></pre>