> districtno and locno are in both tables and arent unique values in either > one, would i still not have to limit by districtno in both tables?
No, by saying "tranmaster.districtno = '67959'" you are limiting the result set for tranmaster to only the few records that have the value specified. R:Base will then attempt to take these (few) records, look at their LOCNO values and find matches in the location table. Any locnos on the location side that were excluded from the tranmaster side of the select will not be eligible for inclusion in the final result set. By the way, is districtno INT or TEXT? If the contents of that field are _really_ integer columns, you might get better performance redefining the column. -- Larry
