Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Michelle
>
>I didn't look closely your city filter :)
>
>tcCity = iif(!empty(tcCity),'city = '+tcCity, 'city = ""')
>
>Would work (unless ANSI is on)?
>Cetin
Thanks, but I don't think you're understanding my question. I'm not having a problem with the filters leading up to the main select. My problem is that once the cursors are filtered, my main join can't tell the difference between a job that has no addresses at all and a job that had no addresses that matched the filter.
I think the idea you sparked might do it, but I need to reboot before I try. My last attempt accidentally did a Cartesian join on rather large tables and my system is running rather slowly now. :)
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