problem with JOIN
when i try to run this query i want it to show me all the moderators names and the forum they are moderating
SELECT ibf_members.name, ibf_forums.name
FROM ibf_members, ibf_forums, ibf_moderators
WHERE ibf_members.id=ibf_moderators.mid AND ibf_moderators.forum_id=ibf_forums.id
but becouse both columns are called "name" it shows me in both columns the name of the forums that are moderated
instad of showing me a column with the moderator names and a column with the moderated forums
how can i fix this?
SELECT m.name, f.name
FROM ibf_members as m
inner join ibf_moderators md ON m.id = md.mid
inner join ibf_forums f ON md.forum_id = f.id
why does what i tried doesnt work?
can u please explain?
and btw it still doesn't help
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)