-like thingie) Re:
Sub-select look-alike?
Hi Bill,
you wrote to me and probably several other people:
If I understand your question, you just need to join with the languages
table twice, using aliases:
select LF.language, LT.language
from language_pairs P, languages LF, languages
Hi,
I have two tables:
languages:
id tinyint(3) unsigned not null,
language varchar(30) not null
language_pairs:
from tinyint(3) unsigned not null,
to tinyint(3) unsigned not null
language_pairs.from and language_pairs.to are linked with
: Sub-select look-alike?
Hi,
I have two tables:
languages:
id tinyint(3) unsigned not null,
language varchar(30) not null
language_pairs:
from tinyint(3) unsigned not null,
to tinyint(3) unsigned not null
language_pairs.from and language_pairs.to
13, 2002 10:13 AM
To: [EMAIL PROTECTED]
Subject: Sub-select look-alike?
Hi,
I have two tables:
languages:
id tinyint(3) unsigned not null,
language varchar(30) not null
language_pairs:
from tinyint(3) unsigned not null,
to tinyint(3) unsigned not null
Hi Greg,
SELECT f.language as From, t.language as To
FROM language f, language t, language_pairs lp
WHERE f.id = lp.from
AND t.id = lp.to;
I really need to get some sleep I think.
So simple, and yet my buggy mind didn't come up with that solution.
Thanks,
//andreas
(sql, query - just to
]
To: [EMAIL PROTECTED]
Subject: Sub-select look-alike?
Date: Wed, 13 Mar 2002 16:12:31 +0100
Hi,
I have two tables:
languages:
id tinyint(3) unsigned not null,
language varchar(30) not null
language_pairs:
from tinyint(3) unsigned not null