Hi. Not sure if this is the place to post this, but I have a question regarding a query I'm trying to write in QMF (using DB2).
I have 3 tables that I'm joining at once. However, I want to make sure I include ALL records from Table 1. I know how to use a LEFT JOIN when I am joining 2 tables, but it does not work when joining more than 2 tables.
In the example below, there will be policy numbers on Tpolicies that have NO records on the tpolicy_hist table. In this query below, those records would be dropped. I need to display them - with a null value in the inq_nbr.
Select a.policy_no, b.birth_date,c.inq_nbr
from Tpolicies a, tpolicy_addr b, tpolicy_hist c