>>>I'm trying to get a filtered set of jobs with the customer's company and the job's address. The user can filter on various tables, so I decided to run the filters on each table individually to avoid having such huge temp cursors.
>>Michelle,
>>Try :
>> LEFT JOIN tc_city ON jobs.jobno = tc_city.jobno
>>Cetin
>
>That will get me all jobs whether there is a matching city or not, so that won't work. But that gives me an idea...
>
>Possibly:
>
>LEFT JOIN tc_city ON (jobs.jobno = tc_city.jobno)
>...
>WHERE (NOT ISNULL(tc_city.jobno)) OR (lcCityFilt = ".T.")
>
>That _might_ work.
>
>I'll go try it. :)
>
>Thanks,
>
>Michelle

I didn't look closely your city filter :)

tcCity = iif(!empty(tcCity),'city = '+tcCity, 'city = ""')

Would work (unless ANSI is on)?
Cetin