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
Thanks for your reply. What's the difference in speed between ANSI-style (BTW, this is a new term for me) and (?) Normal-style? I noticed, that right join takes lot of time in 'Normal' style.
Another question - is where a way to select only one field from Towns in this syntax? Like Towns.Town as TownName?
And I also have third question - very complicated, I think :)
How can I send information about Rushmore optimization (Sys(3054,11)) to some top-level window (right now it behinds the form, which is very inconvenient) and into file (DBF?)?
Ñ íåòåðïåíèåì æäó îòâåòà,
Âñåõ áëàã,
Íàä
If it's not broken, fix it until it is.
My Blog