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.