title: Left Outer Join Vs Individual Queries DB2
body: <p>I am using Mainframe Db2. Its a patient database. My requirement is to fetch different information from 3 tables, TABACC, TABPAY and TABINS. TABACC will always have a row for a patient but TABPAY and TABINS may or may not have a row for a patient in the system.</p>
  
  <p>Which will be more efficient, a QUERY on TABACC with LEFT OUTER JOIN to TABPAY and TABINS 
  or three different queries, one for each TABACC, TABPAY and TABINS.</p>