Null's are attacking!
Hello all,
I'm sure this is simple but I cannot get it to work. As you see below my code returns rows. When I uncomment the parties tables I get no data due to a null value in OE. How do I get the stupid thing to return rows even if my OE is null? I've put in the nvl function a bunch of different ways.
Also, I'm sure you will see a better way to consolidate the line1 fields I have as separate subqueries.
Thanks,
Kkerig
SELECT
oeh.order_number so_num,
oeh.flow_status_code so_status,
oeh.ordered_date,
I'm sure this is simple but I cannot get it to work. As you see below my code returns rows. When I uncomment the parties tables I get no data due to a null value in OE. How do I get the stupid thing to return rows even if my OE is null? I've put in the nvl function a bunch of different ways.
Also, I'm sure you will see a better way to consolidate the line1 fields I have as separate subqueries.
Thanks,
Kkerig
SELECT
oeh.order_number so_num,
oeh.flow_status_code so_status,
oeh.ordered_date,
0