subject:"needed\: smart SQL statement"

needed: smart SQL statement

2001-01-28 Thread Jelle Samshuijzen

Hello smart people, Here's the situation: table: books |BookNumber |Author|Title | | ... | || | 312 |'TWAIN,

RE: needed: smart SQL statement

2001-01-28 Thread Carsten H. Pedersen

Here's the situation: table: books |BookNumber |Author|Title | | ... | || | 312 |'TWAIN, MARK'

RE: needed: smart SQL statement

2001-01-28 Thread Wim Bonis

Hello smart people, My question is: Is this three stage action possible with one SQL statement? Yes you can do a query like: select books.title from words as w1,words as w2, wordlinks as v1,wordlinks as v2,books WHERE (w1.WordNumber =v1.WordNumber ) AND (w2.WordNumber =v2.WordNumber )