Ok, as I said in the other post, I figured out the null problem. But after I took a good look at the data I was getting, I realized my SQL is _not_ working right. I'm getting each trip with multiple pickups and dropoffs.

What am I doing wrong?

By the way, anyone can feel free to join this conversation I seem to be having with myself. :)

-Michelle



>I have the following SQL:
>
>

>SELECT A.ctime, A.ctime_type, A.tripkey, A.clientkey, ;
>       ALLT(B.clname)+", "+ALLT(B.cfname) AS cname, ;
>       NVL(C.cloc," ") AS cpickup, NVL(D.cloc," ") AS cdropoff, ;
>       "   " AS cstatus ;
>   FROM trips A ;
>        LEFT OUTER JOIN clients B ON A.clientkey = B.clientkey ;
>        LEFT OUTER JOIN locations C ON A.ipick_up = C.lockey ;
>        LEFT OUTER JOIN locations D ON A.idrop_off = D.lockey ;
>   INTO ARRAY laTrips ;
>   WHERE NOT DELETED() ;
>   ORDER BY A.ctime
>