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 devel
D]
> Subject: Select: JOIN magic?
>
>
> Hello. I'm trying to select and display from a couple tables
> I have. I have an awards table, which has info on an award a
> user has earned. I've also a user table which lists all the
> users. What I'm trying to do is
Hello. I'm trying to select and display from a couple tables I have. I have an awards
table, which has info on an award a user has earned. I've also a user table which
lists all the users. What I'm trying to do is display information about an award, but
can't find the right SELECT syntax to make