>I don't know if you've solved it yet, but this might work:
>
>SELECT To_ver.*, Clients.clientkey, pickup.cloc AS pickup, dropoff.cloc AS dropoff ;
> FROM To_Ver ;
> LEFT OUTER JOIN Trips ON To_Ver.tripkey = Trips.tripkey ;
> LEFT OUTER JOIN Clients ON Trips.clientkey = Clients.clientkey ;
> LEFT OUTER JOIN Locations Pickup ON Trips.ipickup = Pickup.lockey ;
> LEFT OUTER JOIN Locations Dropoff ON Trips.idropoff = Dropoff.lockey ;
> INTO CURSOR foo
>
>Arne
I tried it with all left joins, and it didn't work. But since then I've discovered I had some other problems with it. So maybe it did work, and just didn't seem like it because of the other problems. I'll have to try that again.
Thanks,
-Michelle
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement