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 1

On 24 feb, 02:51, Carl Forsman <fatwallet... (AT) yahoo (DOT) com> wrote:
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

Because there is a comma missing between b.Word and a.Document and you
are referencing two tables (a, b) but you are only using one and
without alias (data)

This query will never ever work.

Cheers.

Carlos.

Carl Forsman escribió:
You have posted the very same question comp.databases.mysql ... Are you
actually using Oracle?



--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
--