Inner join

[EspenA]

Hi,

I have some small problems with a SQL Query.

ebanews_users:
id | username | first_name | last_name | userlevel

ebanews_userlevels:
name | level

I want to display all users that exists in the ebanews_users-table and the userlevel that belongs to each user. The "userlevel" column in the user-table is an id that's "connected" to the "level" in the userlevel-table. I want do display it like this:

id | username | first_name | last_name | userlevel
65 | EspenA | Espen | Andersson | Administrator

I have created three different userlevels: Administrator, Superuser and User. I tried this SQL Query:

SELECT ebanews_user.id, ebanews_user.username, ebanews_user.first_name, ebanews_user.last_name, ebanews_userlevels.name 
    FROM ebanews_user 
    INNER JOIN ebanews_userlevels 
    ON ebanews_user.id = ebanews_userlevels.id
    ORDER BY id

But it stops after three rows (when all the different userlevels are displayed).

Can anybody help me?

[Thing]

You want to join based on their level. This will display all members who actually have a level. If they do not, then they will not display.

SELECT ebanews_user.id, ebanews_user.username, 
ebanews_user.first_name, ebanews_user.last_name, 
ebanews_userlevels.name 
	FROM ebanews_user 
	INNER JOIN ebanews_userlevels 
	ON ebanews_user.userlevel = ebanews_userlevels.level
	ORDER BY id

[EspenA]

Hi Mongoloid,

Ah, thanks! It works great