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