>Oleg,
>
> Yes, this SQL works and gives me desired result! The problem now is that my application returns the whole where expression. As I understand, I need to devide it this way...
>
>
>
>>Nadya, how about this:
>>SELECT * FROM tranmstr ;
>>left JOIN misclndr on tranmstr.tranid = misclndr.tranid ;
>> and between(tranmstr.extrYear+tranmstr.extrWeek ,oJC.LowWeek,oJC.HighWeek) ;
>> and and SOURCE="S" ;
>>inner JOIN propmstr on tranmstr.propid = propmstr.propid ;
>>inner JOIN sitemstr on tranmstr.propid = sitemstr.propid ;
>> and sitemstr.town="GOSN" and sitemstr.prefcode = "P" ;
>>left JOIN bldgmstr on tranmstr.propid = bldgmstr.propid ;
>>right join Towns on SiteMstr.Town=Towns.Town ;
>>where Towns.town="GOSN" ;
>>INTO TABLE &qry_arg3
>>
>>Oleg
Nadya,
just remember that with ANSI-style joins WHERE restrictions apply AFTER join has been performed.
Ни пуха!
Oleg