How would one translate the following query into DAL - or should I use
executesql (I would like to use the query in SQLFORM.grid):
select B.title, A.title, similarity(A.title, B.title)
from
us2006_2010 B
left join akb_articles A on (A.title % B.title)
where
B.id in
(select A.id from us2006_2010 A
left join akb_articles B on A.ltitle = B.ltitle
where B.title is null)
order by similarity desc
The shortened result looks like this:
B.title1 | A.title1 | 0.960526
B.title2 | A.title2 | 0.905263
B.title1 | A.title3 | 0.511905
...
Johann Spies
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
