table aliases

[fiona cosgrove]

how does valentina use aliases? The previous example I
dont necessarily need them but im sure my other sql
string requires it:

select wstr_id, wstr_number, wstr_title,
(ai.wwri_count)/ length(wstf_fulltext)*1000 as
wstr_score from wstr, wwri as ai, wwrd as a, wstf
where (wstr_id = ai.wwri_wstr_id) and (ai.wwri_wwrd_id
= a.wwrd_id) and wstf_wstr_id = wstr_id and
(a.wwrd_word = 'biology'  ) order by wstr_score desc"

do you now how would I write this for valentina?

Thank you for your help

Fiona

 --- Ruslan Zasukhin <sunshine at public.kherson.ua>
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
> 
> > 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
>
-------------------------------------------------------------
> 
> _______________________________________________
> 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