Hi, I am trying to do a very simple query:

SELECT "OEINVH"."CUSTOMER", "OEINVH"."SHIPTO", "OEINVH"."INVDATE", "OEINVH"."INVNUMBER", "OEINVH"."INVNET", "OECRDH"."CRDNUMBER","OECRDH"."CRDNET"

FROM "OEINVH" LEFT OUTER JOIN "OECRDH" ON "OEINVH"."INVNUMBER" = "OECRDH"."INVNUMBER"

I am almost there, just three issues:

(1) Stop any records that have no data "OEINVH"."SHIPTO" (stop nulls and blanks)
(2) Return "OEINVH"."INVDATE" as an actual date and convert it to the first of the month (ie 20030631 becomes 01/Jun/2003)
(3) Return "OEINVH"."INVNET" - "OECRDH"."CRDNET" (for some reason, when I enter this in I get wrong results.

Many Thanks, Bill