le it ON it.word_id = wt.id
It all depends on how you're doing this, and exactly what you want. :)
Cheers,
Matt
> -Original Message-
> From: Matthias Eireiner [mailto:[EMAIL PROTECTED]
> Sent: 26 April 2004 23:00
> To: [EMAIL PROTECTED]
> Subject: simplifying OR clauses
&
On Mon, 2004-04-26 at 14:59, Matthias Eireiner wrote:
> hi there,
>
> I have a basic question:
> how can I simplify multiple OR statements in a WHERE clause where I have
> only one column to which I refer?
>
> e.g.
>
> SELECT word FROM word_table WHERE id = 1 OR id = 34 OR id = 78 OR id = 8787
On 26 Apr 2004 at 14:59, Matthias Eireiner wrote:
> how can I simplify multiple OR statements in a WHERE clause where I
> have only one column to which I refer?
>
> e.g.
>
> SELECT word FROM word_table WHERE id = 1 OR id = 34 OR id = 78 OR id =
> 8787 OR ...
You want the "IN" operator:
http:/
hi there,
I have a basic question:
how can I simplify multiple OR statements in a WHERE clause where I have
only one column to which I refer?
e.g.
SELECT word FROM word_table WHERE id = 1 OR id = 34 OR id = 78 OR id = 8787
OR ...
I thought I once read over something like this but I can't find