RE: SQL statement problem - outer join where?

2003-06-06 Thread Naveen Nahata
: 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

SQL statement problem - outer join where?

2003-06-06 Thread Saira Somani
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