Linked tables and WHERE clauses. Hoping for a good answer.

[Deane Venske]

On Tue, 10 Feb 2004 08:46:22 +1000, Deane Venske <deane.venske at eduss.com> 
wrote:

> On Tue, 10 Feb 2004 00:31:00 +0200, Ruslan Zasukhin 
> <sunshine at public.kherson.ua> wrote:
>
>> on 2/10/04 12:28 AM, Deane Venske at deane.venske at eduss.com wrote:
>>
>> Hi Deane,
>>
>>> So far all the queries I've changed to use the () work now. Will this 
>>> be
>>> fixed in 2.0?
>>
>> yes
>>
>>> I hope so, I know it's partly laziness that makes me not
>>> want to use brackets, but if there is no need for them it will make 
>>> things
>>> easier.
>>
>> Yes, problem in 1.x was that I have stupidly re-draw design of search 
>> node
>> from ... It seems RB SDK.
>>
>> 2.0 engine will keep AND, OR nodes as arrays, so order is not important.
>>
>
> I probably should have let you know, this problem is in V4MD, incase you 
> need to investigate it on V4MD.
>

Hi Ruslan,

I'm now having problems with another cross table query that I also want to 
use the ORDER BY function in. The query works until I put in ORDER BY and 
then it returns nothing.

-- 
Deane Venske - Senior Programmer
www.eduss.com.au   deane.venske at eduss.com
+61 7 55974600  +61 405148718
Suite 29,  207 Currumburra Rd
Ashmore, Queensland, 4214
Australia