table aliases

[Frank Schima]

On Mar 17, 2004, at 11:01 AM, fiona cosgrove wrote:

>  -------------
>  1) code with ORDER By in the sql string
>  ------------

>  sqlstringS = string(" 'select wstr_id, wstr_title,
>  ai_count from wstr, ai, aw where ai_wstr_id =
>  wstr_id
>  and ai_wwrd_id = aw_id and aw_word = 'biology' order
>  by ai_count' ")

>  ----------------
>  2) code Without the ORDER BY in the sql string, this
>  works
>  ----------------

>   sqlstringS = string(" 'select wstr_id, wstr_title,
>  ai_count from wstr, ai, aw where ai_wstr_id =
>  wstr_id
>  and ai_wwrd_id = aw_id and aw_word = 'biology' '")

I think you many have too many quotes. You seem to enclose your SQL 
String with single quotes inside the string. Remove the single quotes 
surrounding the SQL statement and try it.


-Frank