table aliases

[Ruslan Zasukhin]

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

> I need to do a text search and without tables aliases
> its going to be impossible.

Hmm, actually aliases are MUST TO HAVE feature only when you do
self-recursion table.

In your above example, as far as I see it is possible work without aliases.
Right?

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