query
From: Carl Forsman <fatwallet951_at_yahoo.com>
Date: Mon, 23 Feb 2009 17:51:33 -0800
Message-ID: <vkk6q4l9o768gnhmef4c720j5erq5ah0lk_at_4ax.com>
Why the following query does not work?
select a.Word, b.Word a.Document from data where ABS(a.Position - b.Position) < 3 and a.Document = b.Document
Date: Mon, 23 Feb 2009 17:51:33 -0800
Message-ID: <vkk6q4l9o768gnhmef4c720j5erq5ah0lk_at_4ax.com>
Why the following query does not work?
select a.Word, b.Word a.Document from data where ABS(a.Position - b.Position) < 3 and a.Document = b.Document
I have a Table stores keywords + position of the word + document number 1 or 2 ... the word in.
Word Position Document Great 1 1 Wall 2 1 China 3 1 Dog 3 2 Cat 7 2
I would like to output all word that are close related ... position of 2 word do not more than 3 word apart :
The output should be:
(Word1)(Word2)(Document#)
Great Wall 1 Wall China 1 Great China 1Received on Mon Feb 23 2009 - 19:51:33 CST