>Nadya,
>
>No your code will not give you what you want as the towns in BldMstr are NOT in Towns, try this instead;
>
>
>
>select town, fullname, ccode, county from Towns where ... ;
> union ;
>select BldMstr.town, space(21) as fullname, ;
> BldMstr.ccode, county from BldMstr ;
> order by 1 into cursor curTowns
>
>
>
>note the inner join was removed.
Hi Jim,
I made inner join by ccode, not by town. BldMstr doesn't have county field (description), but has valid ccode field. So that's why I added join to towns table, which contains ccode county town fullname rcode registry and lots of other stuff about towns. The data are not normalized, we don't have separate Counties or Registries tables, but that's ok.
If it's not broken, fix it until it is.
My Blog