table aliases

[Ruslan Zasukhin]

On 3/17/04 4:28 PM, "fiona cosgrove" <fionacosgrove at yahoo.co.uk> wrote:

Hi Fiona.

> Thank you for your advice.
> 
> My boss tested my sql string on his V4Md but we kept
> getting a syntax error (604) when we used the "order
> by" keyword. is it case specific??
> 
> Why would the order by statement case an error?
> Here is my string at the moment:
> 
> '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'


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
-------------------------------------------------------------