SELECT t1.name AS Nomi, t2.name AS Propo
FROM award t0 INNER JOIN user t1 ON t0.nominee=t1.uid
INNER JOIN user t2 ON t0.proposer=t2.uid
-Original Message-
From: Michael Carter [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 30, 2002 11:51 AM
To: [EMAIL PROTECTED]
Subject:
try aliasing your right table twice and join it
both ways. something like:
select award.*, a.name, b.name
from ( award
left join user a on award.uid = a.uid)
left join user b on award.uid = b.uid
if you have a windows box to use as a front end,
download a copy of corereader to help you