ORDER BY - join column

[ohyeah]

Hi, I am writing a small search engine.
There are two tables. The first one holds the search engine main index, the second one is link table.
I have the following query that retrieves results. I would like to sort the results by:
dbo.OCCURS2(LOWER(:query),se_links.anchor). se_links.anchor obviously comes from se_links table, so I get an error. Is it possible to done in one query?
I'm using MSSQL 2005. Thanks.
PS. Function OCCURS2 returns number of occurrences of one string in other.

select 
                             id as Id, 
                             uri as ElementUri,
                             size as Size,
                             modified_date as ModifiedDate,
                             title as Title,
                             text as Text,                             
                             dbo.OCCURS2(LOWER(:query),Title) as TitleOcc,
                             dbo.OCCURS2(LOWER(:query),Text) as BodyOcc  
                    FROM se_index 
                    WHERE (title LIKE :query) OR
                          (text LIKE :query) OR
                          (id IN
                              (SELECT    se_links.target_index_id
                                FROM          se_links INNER JOIN
                                               se_index AS se_index_1 ON 
                                        se_links.target_index_id = se_index_1.id AND 
                                        se_links.anchor LIKE :query))