Hi, Michelle. I'm a newbie with SQL, too, but since you don't like talking to yourself...< bg >

Is it because of the order in which you issue the joins?

>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. :)