On 11-Jul-01 Jaime Teng wrote:
> Hi,
>
> I have a table:
> mysql> describe crossref;
> +---+--+--+-+
>| Field | Type | Null | Key |
> +---+--+--+-+
>| word | char(15) | | MUL |
>| id| int(10) unsigned | |
.word='word2'
AND c3.word='word3'
AND c1.id=c2.id
AND c1.id=c3.id
- Original Message -
From: "Jaime Teng" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 13:03
Subject: help me wi
a.id from crossref a, crossref b
where a.id=b.id
and a.word='registers'
and b.word='tintin'
result: 1604
---
Dmitri Lubinski
-Original Message-
From: Jaime Teng [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 9:04 AM
To: [EMAIL PROTECTED]
Hi,
I have a table:
mysql> describe crossref;
+---+--+--+-+
| Field | Type | Null | Key |
+---+--+--+-+
| word | char(15) | | MUL |
| id| int(10) unsigned | | MUL |
+---+--+--+-+
