table aliases

[fiona cosgrove]

Hi Ruslan 

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'

any suggestions you have i would appriciate.


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