table aliases

[fiona cosgrove]

 Hi Ruslan 

that was silly of me, I made a typo in my email. The
field which I am ordering by is now in the SELECT
statement. Unfortunalty I am still getting a 604
syntax error. This is the sql:

'select wstr_id, wstr_title, ai_count 
from wstr, ai, aw 
where ai_wstr_id = wstr_id and ai_wwrd_id = aw_id and
aw_word = 'biology' order by ai_count'



However if I take out the ORDER BY the string works:

'select wstr_id, wstr_title, ai_count 
from wstr, ai, aw 
where ai_wstr_id = wstr_id and ai_wwrd_id = aw_id and
aw_word = 'biology''

I dont understand why this is happening. I am using
the sql within director with the v4md xtra.

However, Both SQL strings work perfectly if I test it
in ViSql carbon instead of director. 

 Could the error possibly be to do with the V4MD xtra?

We are using the demo version to see if it works with
our system before we decide to buy it. Is it maybe the
demo version?

Thanks again.


> select wstr_number, wstr_title
> from wstr, ai, aw
>  where 
>     ai_wstr_id = wstr_id and ai_wwrd_id = aw_id
>     and aw_word = 'biology'
> order by ai_count'
> 
> 
> But you have not SELECT field by which you do ORDER
> BY.
> 
> 
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need
> for speed ]
>
-------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
> 
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
>
-------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina 


	
	
		
___________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html