: SQL statement problem - outer join where?
>
>
> Hi,
>
> I'm facing a bit of an struggle with this SQL statement. The one below
> results in the correct number of records (601). However, when
> I add the
> tables ITEM_C (Customer Part Number) using CUST_NUM and ITEM
Hi,
I'm facing a bit of an struggle with this SQL statement. The one below
results in the correct number of records (601). However, when I add the
tables ITEM_C (Customer Part Number) using CUST_NUM and ITEM_NUM I get
fewer records (526). The reason is because there are item numbers which
do not h