-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
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;
--Greg Johnson
-Original Message-
From: Andreas Frøsting [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 10:13 AM
To: [EMAIL PROTECTED]
Subject:
Is that what you want?
SELECT languages.language, languages.fieldN, .., language_pairs.fieldX
FROM language_pairs INNER JOIN
Languages ON languages.id=language_pairs.id WHERE /* conditions */
-Original Message-
From: Andreas Frøsting [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March
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
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 LT
where LF.id = P.from and LT.id = P.to;
From: =?iso-8859-1?Q?Andreas_Fr=F8sting?= [EMAIL PROTECTED]
To: