table aliases

[Frank Schima]

Hi all,


On Mar 16, 2004, at 12:08 PM, Ruslan Zasukhin wrote:

> On 3/16/04 6:58 PM, "fiona cosgrove" <fionacosgrove at yahoo.co.uk> wrote:
>
>> Does valentina support table aliases?
>
> yes
>
>> Would the following sql work within valentina:
>>
>>
>> "select wstr_id, wstr_number, wstr_title from wstr,
>> wwri as ai, wwrd as a where( wstr_id = ai.wwri_wstr_id
>> ) and (ai.wwri_wwrd_id = a.wwrd_id ) and (a.wwrd_word
>> = 'biology'  ) order by wstr_number"
>>
>> 'Wwri as ai' being one of the aliases.
>
> Must work

You have to remove the word "as". Just use a space between the table 
and the alias.


Best regards,
Frank